using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VVKKOPF
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {

            switch (app.company)
            {
                case "YGR":
                case "YCC":
                case "TST":
                case "UBT":
                default:
                    #region=========
                    dwReturn["VKKMANDANT"] = app.Mandant;
                    dwReturn["VKKSA"] = "  ";
                    dwReturn["VKKAUFKRS"] = "  ";
                    dwReturn["VKKAUFLFD"] = "000007";
                    dwReturn["VKKAENDST"] = "000";
                    dwReturn["VKKAENDZL"] = "0";
                    dwReturn["VKKAENDBEN"] = "        ";
                    dwReturn["VKKAENDDAT"] = "0";
                    dwReturn["VKKNEUBEN"] = "        ";
                    dwReturn["VKKNEUDAT"] = "0";
                    dwReturn["VKKAESTAT"] = "S";
                    dwReturn["VKKAUFART"] = "NA";
                    dwReturn["VKKKUNDNR"] = "00000000";
                    dwReturn["VKKVB"] = "   ";
                    dwReturn["VKKVG"] = "   ";
                    dwReturn["VKKADRSL"] = "        ";
                    dwReturn["VKKVERBNR"] = "        ";
                    dwReturn["VKKZENTR"] = "        ";
                    dwReturn["VKKZENTRR"] = " ";
                    dwReturn["VKKKREDKDNR"] = "00000000";
                    dwReturn["VKKKDARTBEZ"] = "K";
                    dwReturn["VKKORDER"] = "    ";
                    dwReturn["VKKANSPRECH"] = "        ";
                    dwReturn["VKKANSPZUS"] = "                          ";
                    dwReturn["VKKBESTNR"] = "               ";
                    dwReturn["VKKBESTDAT"] = "0";
                    dwReturn["VKKGLTVON"] = "0";
                    dwReturn["VKKGLTBIS"] = "0";
                    dwReturn["VKKETAB"] = "0";
                    dwReturn["VKKBESTSB"] = "              ";
                    dwReturn["VKKAEDAT"] = "0";
                    dwReturn["VKKSACHBE"] = "        ";
                    dwReturn["VKKPRGRP"] = "RMB     ";
                    dwReturn["VKKPRGRPV"] = "        ";
                    dwReturn["VKKPRGRPZ"] = "        ";
                    dwReturn["VKKPRGRPSTD"] = "        ";
                    dwReturn["VKKPROJNR"] = "00000";
                    dwReturn["VKKVKART"] = "   ";
                    dwReturn["VKKKUNDNRST"] = "        ";
                    dwReturn["VKKABNGRPST"] = "   ";
                    dwReturn["VKKGLOBAL"] = " ";
                    dwReturn["VKKKOMENGE"] = "0";
                    dwReturn["VKKEINGET"] = "0";
                    dwReturn["VKKOFFEN"] = "0";
                    dwReturn["VKKEINGETOV"] = "0";
                    dwReturn["VKKEINGETPO"] = "0";
                    dwReturn["VKKCORQTY"] = "0";
                    dwReturn["VKKLIMGWO"] = "0";
                    dwReturn["VKKMEEH"] = "   ";
                    dwReturn["VKKMEEHGRP"] = " ";
                    dwReturn["VKKMEEHFKT"] = "000000000000";
                    dwReturn["VKKKOMENGET1"] = "0";
                    dwReturn["VKKKOMENGET2"] = "0";
                    dwReturn["VKKKOMENGET3"] = "0";
                    dwReturn["VKKKOMENGET4"] = "0";
                    dwReturn["VKKEINTT1"] = "0";
                    dwReturn["VKKEINTT2"] = "0";
                    dwReturn["VKKEINTT3"] = "0";
                    dwReturn["VKKEINTT4"] = "0";
                    dwReturn["VKKOFFENT1"] = "0";
                    dwReturn["VKKOFFENT2"] = "0";
                    dwReturn["VKKOFFENT3"] = "0";
                    dwReturn["VKKOFFENT4"] = "0";
                    dwReturn["VKKEINTTOV1"] = "0";
                    dwReturn["VKKEINTTOV2"] = "0";
                    dwReturn["VKKEINTTOV3"] = "0";
                    dwReturn["VKKEINTTOV4"] = "0";
                    dwReturn["VKKEINTTPO1"] = "0";
                    dwReturn["VKKEINTTPO2"] = "0";
                    dwReturn["VKKEINTTPO3"] = "0";
                    dwReturn["VKKEINTTPO4"] = "0";
                    dwReturn["VKKCORQTYT1"] = "0";
                    dwReturn["VKKCORQTYT2"] = "0";
                    dwReturn["VKKCORQTYT3"] = "0";
                    dwReturn["VKKCORQTYT4"] = "0";
                    dwReturn["VKKLIMGWOT1"] = "0";
                    dwReturn["VKKLIMGWOT2"] = "0";
                    dwReturn["VKKLIMGWOT3"] = "0";
                    dwReturn["VKKLIMGWOT4"] = "0";
                    dwReturn["VKKRSTBEZ"] = "      ";
                    dwReturn["VKKOPTION"] = " ";
                    dwReturn["VKKOPTANBIS"] = "0";
                    dwReturn["VKKOPTANAM"] = "0";
                    dwReturn["VKKDECKPROZ"] = "1000";
                    dwReturn["VKKWDECKDAT"] = " ";
                    dwReturn["VKKUEBEINT"] = "0";
                    dwReturn["VKKMINBEST"] = "0";
                    dwReturn["VKKMAXBEST"] = "0";
                    dwReturn["VKKSCHRAST"] = " ";
                    dwReturn["VKKGESMENGE1"] = "0";
                    dwReturn["VKKGESMENGE2"] = "0";
                    dwReturn["VKKGESMENGE3"] = "0";
                    dwReturn["VKKGESMENGE4"] = "0";
                    dwReturn["VKKGESWERT"] = "0";
                    dwReturn["VKKCOVPRC"] = "1000";
                    dwReturn["VKKAKKREDNR"] = "                    ";
                    dwReturn["VKKGESSTA"] = "  ";
                    dwReturn["VKKKDSTA"] = "10";
                    dwReturn["VKKAUFSTA"] = "20";
                    dwReturn["VKKPOSSTA"] = "30";
                    dwReturn["VKKSTA4"] = "40";
                    dwReturn["VKKKURS"] = "0010000";
                    dwReturn["VKKBETRAG"] = "0001";
                    dwReturn["VKKVKURS"] = "0000000";
                    dwReturn["VKKVBETRAG"] = "0000";
                    dwReturn["VKKSCHWPLU"] = "0";
                    dwReturn["VKKSCHWMIN"] = "0";
                    dwReturn["VKKHWAEHRSL"] = "RMB";
                    dwReturn["VKKHEUROKURS"] = "0";
                    dwReturn["VKKHEUROKURSVK"] = " ";
                    dwReturn["VKKFEUROKURS"] = "0";
                    dwReturn["VKKFEUROKURSVK"] = " ";
                    dwReturn["VKKALTWAEHR"] = "   ";
                    dwReturn["VKKALTWAEHRF"] = "0";
                    dwReturn["VKKVALUTA"] = "000";
                    dwReturn["VKKVALDAT"] = "0";
                    dwReturn["VKKWAEHRSL"] = "RMB";
                    dwReturn["VKKZAHLBED"] = "300";
                    dwReturn["VKKEKON"] = "        ";
                    dwReturn["VKKKDVKL"] = "   ";
                    dwReturn["VKKLIEFBED"] = "   ";
                    dwReturn["VKKLANDU"] = "   ";
                    dwReturn["VKKPLZU"] = "            ";
                    dwReturn["VKKORTU"] = "                                        ";
                    dwReturn["VKKBZU"] = "  ";
                    dwReturn["VKKBZBEZU"] = "             ";
                    dwReturn["VKKCOUNTYU"] = "    ";
                    dwReturn["VKKCITYU"] = "    ";
                    dwReturn["VKKLIEFKOMP"] = "N";
                    dwReturn["VKKVERSART"] = "   ";
                    dwReturn["VKKSPED"] = "   ";
                    dwReturn["VKKZUSATZ"] = "                                                            ";
                    dwReturn["VKKDRBEST"] = "N";
                    dwReturn["VKKBSTDAT"] = "0";
                    dwReturn["VKKANGETEXT"] = " ";
                    dwReturn["VKKANGEWIE"] = "0";
                    dwReturn["VKKBESTTEXT"] = " ";
                    dwReturn["VKKBESTWIE"] = "0";
                    dwReturn["VKKLIEFTEXT"] = " ";
                    dwReturn["VKKLIEFWIE"] = "0";
                    dwReturn["VKKRECHTEXT"] = " ";
                    dwReturn["VKKRECHWIE"] = "0";
                    dwReturn["VKKLVORTEXT"] = " ";
                    dwReturn["VKKLVORWIE"] = "0";
                    dwReturn["VKKIVVTTEXT"] = " ";
                    dwReturn["VKKIVVTWIE"] = "0";
                    dwReturn["VKKIVDITEXT"] = " ";
                    dwReturn["VKKIVDIWIE"] = "0";
                    dwReturn["VKKAGT"] = "        ";
                    dwReturn["VKKANGEALLG"] = "   ";
                    dwReturn["VKKBESTALLG"] = "   ";
                    dwReturn["VKKLIEFALLG"] = "   ";
                    dwReturn["VKKRECHALLG"] = "   ";
                    dwReturn["VKKLVORALLG"] = "   ";
                    dwReturn["VKKIVVTALLG"] = "   ";
                    dwReturn["VKKIVDIALLG"] = "   ";
                    dwReturn["VKKANL1TXT"] = "   ";
                    dwReturn["VKKANL2TXT"] = "   ";
                    dwReturn["VKKANL3TXT"] = "   ";
                    dwReturn["VKKDBLATT"] = " ";
                    dwReturn["VKKTBRIEF"] = " ";
                    dwReturn["VKKARTBILD"] = " ";
                    dwReturn["VKKFORMAT"] = " ";
                    dwReturn["VKKZEUGNIS"] = " ";
                    dwReturn["VKKRES1"] = " ";
                    dwReturn["VKKRES2"] = " ";
                    dwReturn["VKKVKZUABVH"] = " ";
                    dwReturn["VKKVKZUADR"] = " ";
                    dwReturn["VKKKZPRNEU"] = "N";
                    dwReturn["VKKKZFRNEU"] = "N";
                    dwReturn["VKKVAEAKZ"] = "J";
                    dwReturn["VKKMUKRS"] = "  ";
                    dwReturn["VKKMULFD"] = "000000";
                    dwReturn["VKKMUPOS"] = "000";
                    dwReturn["VKKCPKRS"] = "  ";
                    dwReturn["VKKCPLFD"] = "000000";
                    dwReturn["VKKCPPOS"] = "000";
                    dwReturn["VKKEDIKZ"] = " ";
                    dwReturn["VKKKOMMNR"] = "                    ";
                    dwReturn["VKKEDIDAT"] = "0";
                    dwReturn["VKKEDIZEIT"] = "0";
                    dwReturn["VKKABSAUFART"] = "  ";
                    dwReturn["VKKARCHKZ"] = " ";
                    dwReturn["VKKARCHDAT"] = "00000000";
                    dwReturn["VKKARCHBEL"] = "00000000";
                    dwReturn["VKKOPITEM"] = "          ";
                    dwReturn["VKKABSCHR"] = "0000";
                    dwReturn["VKKSFEUCHTE"] = "0000";
                    dwReturn["VKKAFEUCHTE"] = "0000";
                    dwReturn["VKKFEUKZ"] = " ";
                    dwReturn["VKKABRKZ"] = " ";
                    dwReturn["VKKVTYP"] = " ";
                    dwReturn["VKKEXMANDANT"] = "  ";
                    dwReturn["VKKWEGBINICH"] = " ";
                    dwReturn["VKKOFFNEU"] = "00000000";
                    dwReturn["VKKINDEXNA1"] = "      ";
                    dwReturn["VKKINDEXBA1"] = "0";
                    dwReturn["VKKINDEXHS1"] = "0";
                    dwReturn["VKKINDEXNA2"] = "      ";
                    dwReturn["VKKINDEXBA2"] = "0";
                    dwReturn["VKKINDEXHS2"] = "0";
                    dwReturn["VKKINDEXNA3"] = "      ";
                    dwReturn["VKKINDEXBA3"] = "0";
                    dwReturn["VKKINDEXHS3"] = "0";
                    dwReturn["VKKHUELBE"] = " ";
                    dwReturn["VKKRATIFI"] = " ";
                    dwReturn["VKKMU1ANZ"] = "0";
                    dwReturn["VKKMU1GR"] = "0";
                    dwReturn["VKKMU1ME"] = "   ";
                    dwReturn["VKKMU1PROMG"] = "0";
                    dwReturn["VKKMU2ANZ"] = "0";
                    dwReturn["VKKMU2GR"] = "0";
                    dwReturn["VKKMU2ME"] = "   ";
                    dwReturn["VKKMU2PROMG"] = "0";
                    dwReturn["VKKSPARTE"] = "  ";
                    dwReturn["VKKEINSATZG"] = "    ";
                    dwReturn["VKKVERWEND"] = "    ";
                    dwReturn["VKKERL"] = " ";
                    dwReturn["VKKRD"] = "  ";
                    dwReturn["VKKFILLER"] = "                                             ";
                    #endregion
                    break;
                case "JLT":
                    #region=========
                    dwReturn["VKKMANDANT"] = app.Mandant;
                    dwReturn["VKKSA"] = "  ";
                    dwReturn["VKKAUFKRS"] = "  ";
                    dwReturn["VKKAUFLFD"] = "000007";
                    dwReturn["VKKAENDST"] = "000";
                    dwReturn["VKKAENDZL"] = "0";
                    dwReturn["VKKAENDBEN"] = "        ";
                    dwReturn["VKKAENDDAT"] = "0";
                    dwReturn["VKKNEUBEN"] = "        ";
                    dwReturn["VKKNEUDAT"] = "0";
                    dwReturn["VKKAESTAT"] = "S";
                    dwReturn["VKKAUFART"] = "NA";
                    dwReturn["VKKKUNDNR"] = "00000000";
                    dwReturn["VKKVB"] = "   ";
                    dwReturn["VKKVG"] = "   ";
                    dwReturn["VKKADRSL"] = "        ";
                    dwReturn["VKKVERBNR"] = "        ";
                    dwReturn["VKKZENTR"] = "        ";
                    dwReturn["VKKZENTRR"] = " ";
                    dwReturn["VKKKREDKDNR"] = "00000000";
                    dwReturn["VKKKDARTBEZ"] = "K";
                    dwReturn["VKKORDER"] = "    ";
                    dwReturn["VKKANSPRECH"] = "        ";
                    dwReturn["VKKANSPZUS"] = "                          ";
                    dwReturn["VKKBESTNR"] = "               ";
                    dwReturn["VKKBESTDAT"] = "0";
                    dwReturn["VKKGLTVON"] = "0";
                    dwReturn["VKKGLTBIS"] = "0";
                    dwReturn["VKKETAB"] = "0";
                    dwReturn["VKKBESTSB"] = "              ";
                    dwReturn["VKKAEDAT"] = "0";
                    dwReturn["VKKSACHBE"] = "        ";
                    dwReturn["VKKPRGRP"] = "RMB     ";
                    dwReturn["VKKPRGRPV"] = "        ";
                    dwReturn["VKKPRGRPZ"] = "        ";
                    dwReturn["VKKPRGRPSTD"] = "        ";
                    dwReturn["VKKPROJNR"] = "00000";
                    dwReturn["VKKVKART"] = "   ";
                    dwReturn["VKKKUNDNRST"] = "        ";
                    dwReturn["VKKABNGRPST"] = "   ";
                    dwReturn["VKKGLOBAL"] = " ";
                    dwReturn["VKKKOMENGE"] = "0";
                    dwReturn["VKKEINGET"] = "0";
                    dwReturn["VKKOFFEN"] = "0";
                    dwReturn["VKKEINGETOV"] = "0";
                    dwReturn["VKKEINGETPO"] = "0";
                    dwReturn["VKKCORQTY"] = "0";
                    dwReturn["VKKLIMGWO"] = "0";
                    dwReturn["VKKMEEH"] = "   ";
                    dwReturn["VKKMEEHGRP"] = " ";
                    dwReturn["VKKMEEHFKT"] = "000000000000";
                    dwReturn["VKKKOMENGET1"] = "0";
                    dwReturn["VKKKOMENGET2"] = "0";
                    dwReturn["VKKKOMENGET3"] = "0";
                    dwReturn["VKKKOMENGET4"] = "0";
                    dwReturn["VKKEINTT1"] = "0";
                    dwReturn["VKKEINTT2"] = "0";
                    dwReturn["VKKEINTT3"] = "0";
                    dwReturn["VKKEINTT4"] = "0";
                    dwReturn["VKKOFFENT1"] = "0";
                    dwReturn["VKKOFFENT2"] = "0";
                    dwReturn["VKKOFFENT3"] = "0";
                    dwReturn["VKKOFFENT4"] = "0";
                    dwReturn["VKKEINTTOV1"] = "0";
                    dwReturn["VKKEINTTOV2"] = "0";
                    dwReturn["VKKEINTTOV3"] = "0";
                    dwReturn["VKKEINTTOV4"] = "0";
                    dwReturn["VKKEINTTPO1"] = "0";
                    dwReturn["VKKEINTTPO2"] = "0";
                    dwReturn["VKKEINTTPO3"] = "0";
                    dwReturn["VKKEINTTPO4"] = "0";
                    dwReturn["VKKCORQTYT1"] = "0";
                    dwReturn["VKKCORQTYT2"] = "0";
                    dwReturn["VKKCORQTYT3"] = "0";
                    dwReturn["VKKCORQTYT4"] = "0";
                    dwReturn["VKKLIMGWOT1"] = "0";
                    dwReturn["VKKLIMGWOT2"] = "0";
                    dwReturn["VKKLIMGWOT3"] = "0";
                    dwReturn["VKKLIMGWOT4"] = "0";
                    dwReturn["VKKRSTBEZ"] = "      ";
                    dwReturn["VKKOPTION"] = " ";
                    dwReturn["VKKOPTANBIS"] = "0";
                    dwReturn["VKKOPTANAM"] = "0";
                    dwReturn["VKKDECKPROZ"] = "1000";
                    dwReturn["VKKWDECKDAT"] = " ";
                    dwReturn["VKKUEBEINT"] = "0";
                    dwReturn["VKKMINBEST"] = "0";
                    dwReturn["VKKMAXBEST"] = "0";
                    dwReturn["VKKSCHRAST"] = " ";
                    dwReturn["VKKGESMENGE1"] = "0";
                    dwReturn["VKKGESMENGE2"] = "0";
                    dwReturn["VKKGESMENGE3"] = "0";
                    dwReturn["VKKGESMENGE4"] = "0";
                    dwReturn["VKKGESWERT"] = "0";
                    dwReturn["VKKCOVPRC"] = "1000";
                    dwReturn["VKKAKKREDNR"] = "                    ";
                    dwReturn["VKKGESSTA"] = "  ";
                    dwReturn["VKKKDSTA"] = "10";
                    dwReturn["VKKAUFSTA"] = "20";
                    dwReturn["VKKPOSSTA"] = "30";
                    dwReturn["VKKSTA4"] = "40";
                    dwReturn["VKKKURS"] = "0010000";
                    dwReturn["VKKBETRAG"] = "0001";
                    dwReturn["VKKVKURS"] = "0000000";
                    dwReturn["VKKVBETRAG"] = "0000";
                    dwReturn["VKKSCHWPLU"] = "0";
                    dwReturn["VKKSCHWMIN"] = "0";
                    dwReturn["VKKHWAEHRSL"] = "RMB";
                    dwReturn["VKKHEUROKURS"] = "0";
                    dwReturn["VKKHEUROKURSVK"] = " ";
                    dwReturn["VKKFEUROKURS"] = "0";
                    dwReturn["VKKFEUROKURSVK"] = " ";
                    dwReturn["VKKALTWAEHR"] = "   ";
                    dwReturn["VKKALTWAEHRF"] = "0";
                    dwReturn["VKKVALUTA"] = "000";
                    dwReturn["VKKVALDAT"] = "0";
                    dwReturn["VKKWAEHRSL"] = "RMB";
                    dwReturn["VKKZAHLBED"] = "300";
                    dwReturn["VKKEKON"] = "        ";
                    dwReturn["VKKKDVKL"] = "   ";
                    dwReturn["VKKLIEFBED"] = "   ";
                    dwReturn["VKKLANDU"] = "   ";
                    dwReturn["VKKPLZU"] = "            ";
                    dwReturn["VKKORTU"] = "                                        ";
                    dwReturn["VKKBZU"] = "  ";
                    dwReturn["VKKBZBEZU"] = "             ";
                    dwReturn["VKKCOUNTYU"] = "    ";
                    dwReturn["VKKCITYU"] = "    ";
                    dwReturn["VKKLIEFKOMP"] = "N";
                    dwReturn["VKKVERSART"] = "   ";
                    dwReturn["VKKSPED"] = "   ";
                    dwReturn["VKKZUSATZ"] = "                                                            ";
                    dwReturn["VKKDRBEST"] = "N";
                    dwReturn["VKKBSTDAT"] = "0";
                    dwReturn["VKKANGETEXT"] = " ";
                    dwReturn["VKKANGEWIE"] = "0";
                    dwReturn["VKKBESTTEXT"] = " ";
                    dwReturn["VKKBESTWIE"] = "0";
                    dwReturn["VKKLIEFTEXT"] = " ";
                    dwReturn["VKKLIEFWIE"] = "0";
                    dwReturn["VKKRECHTEXT"] = " ";
                    dwReturn["VKKRECHWIE"] = "0";
                    dwReturn["VKKLVORTEXT"] = " ";
                    dwReturn["VKKLVORWIE"] = "0";
                    dwReturn["VKKIVVTTEXT"] = " ";
                    dwReturn["VKKIVVTWIE"] = "0";
                    dwReturn["VKKIVDITEXT"] = " ";
                    dwReturn["VKKIVDIWIE"] = "0";
                    dwReturn["VKKAGT"] = "        ";
                    dwReturn["VKKANGEALLG"] = "   ";
                    dwReturn["VKKBESTALLG"] = "   ";
                    dwReturn["VKKLIEFALLG"] = "   ";
                    dwReturn["VKKRECHALLG"] = "   ";
                    dwReturn["VKKLVORALLG"] = "   ";
                    dwReturn["VKKIVVTALLG"] = "   ";
                    dwReturn["VKKIVDIALLG"] = "   ";
                    dwReturn["VKKANL1TXT"] = "   ";
                    dwReturn["VKKANL2TXT"] = "   ";
                    dwReturn["VKKANL3TXT"] = "   ";
                    dwReturn["VKKDBLATT"] = " ";
                    dwReturn["VKKTBRIEF"] = " ";
                    dwReturn["VKKARTBILD"] = " ";
                    dwReturn["VKKFORMAT"] = " ";
                    dwReturn["VKKZEUGNIS"] = " ";
                    dwReturn["VKKRES1"] = " ";
                    dwReturn["VKKRES2"] = " ";
                    dwReturn["VKKVKZUABVH"] = " ";
                    dwReturn["VKKVKZUADR"] = " ";
                    dwReturn["VKKKZPRNEU"] = "N";
                    dwReturn["VKKKZFRNEU"] = "N";
                    dwReturn["VKKVAEAKZ"] = "J";
                    dwReturn["VKKMUKRS"] = "  ";
                    dwReturn["VKKMULFD"] = "000000";
                    dwReturn["VKKMUPOS"] = "000";
                    dwReturn["VKKCPKRS"] = "  ";
                    dwReturn["VKKCPLFD"] = "000000";
                    dwReturn["VKKCPPOS"] = "000";
                    dwReturn["VKKEDIKZ"] = " ";
                    dwReturn["VKKKOMMNR"] = "                    ";
                    dwReturn["VKKEDIDAT"] = "0";
                    dwReturn["VKKEDIZEIT"] = "0";
                    dwReturn["VKKABSAUFART"] = "  ";
                    dwReturn["VKKARCHKZ"] = " ";
                    dwReturn["VKKARCHDAT"] = "00000000";
                    dwReturn["VKKARCHBEL"] = "00000000";
                    dwReturn["VKKOPITEM"] = "          ";
                    dwReturn["VKKABSCHR"] = "0000";
                    dwReturn["VKKSFEUCHTE"] = "0000";
                    dwReturn["VKKAFEUCHTE"] = "0000";
                    dwReturn["VKKFEUKZ"] = " ";
                    dwReturn["VKKABRKZ"] = " ";
                    dwReturn["VKKVTYP"] = " ";
                    dwReturn["VKKEXMANDANT"] = "  ";
                    dwReturn["VKKWEGBINICH"] = " ";
                    dwReturn["VKKOFFNEU"] = "00000000";
                    dwReturn["VKKINDEXNA1"] = "      ";
                    dwReturn["VKKINDEXBA1"] = "0";
                    dwReturn["VKKINDEXHS1"] = "0";
                    dwReturn["VKKINDEXNA2"] = "      ";
                    dwReturn["VKKINDEXBA2"] = "0";
                    dwReturn["VKKINDEXHS2"] = "0";
                    dwReturn["VKKINDEXNA3"] = "      ";
                    dwReturn["VKKINDEXBA3"] = "0";
                    dwReturn["VKKINDEXHS3"] = "0";
                    dwReturn["VKKHUELBE"] = " ";
                    dwReturn["VKKRATIFI"] = " ";
                    dwReturn["VKKMU1ANZ"] = "0";
                    dwReturn["VKKMU1GR"] = "0";
                    dwReturn["VKKMU1ME"] = "   ";
                    dwReturn["VKKMU1PROMG"] = "0";
                    dwReturn["VKKMU2ANZ"] = "0";
                    dwReturn["VKKMU2GR"] = "0";
                    dwReturn["VKKMU2ME"] = "   ";
                    dwReturn["VKKMU2PROMG"] = "0";
                    dwReturn["VKKSPARTE"] = "  ";
                    dwReturn["VKKEINSATZG"] = "    ";
                    dwReturn["VKKVERWEND"] = "    ";
                    dwReturn["VKKERL"] = " ";
                    dwReturn["VKKRD"] = "  ";
                    dwReturn["VKKFILLER"] = "                                             ";
                    #endregion
                    break;
            }
        }

        public DataSet Convert2VKKOPF(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryVKKOPF(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].Rows.Add();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "YCC":
                    #region=========
                    dwReturn["VKKMANDANT"] = app.Mandant;
                    dwReturn["VKKSA"] = "  ";
                    dwReturn["VKKAUFKRS"] = "  ";
                    dwReturn["VKKAUFLFD"] = "000007";
                    dwReturn["VKKAENDST"] = "000";
                    dwReturn["VKKAENDZL"] = "0";
                    dwReturn["VKKAENDBEN"] = "        ";
                    dwReturn["VKKAENDDAT"] = "0";
                    dwReturn["VKKNEUBEN"] = "        ";
                    dwReturn["VKKNEUDAT"] = "0";
                    dwReturn["VKKAESTAT"] = "S";
                    dwReturn["VKKAUFART"] = "NA";
                    dwReturn["VKKKUNDNR"] = "00000000";
                    dwReturn["VKKVB"] = "   ";
                    dwReturn["VKKVG"] = "   ";
                    dwReturn["VKKADRSL"] = "        ";
                    dwReturn["VKKVERBNR"] = "        ";
                    dwReturn["VKKZENTR"] = "        ";
                    dwReturn["VKKZENTRR"] = " ";
                    dwReturn["VKKKREDKDNR"] = "00000000";
                    dwReturn["VKKKDARTBEZ"] = "K";
                    dwReturn["VKKORDER"] = "    ";
                    dwReturn["VKKANSPRECH"] = "        ";
                    dwReturn["VKKANSPZUS"] = "                          ";
                    dwReturn["VKKBESTNR"] = "               ";
                    dwReturn["VKKBESTDAT"] = "0";
                    dwReturn["VKKGLTVON"] = "0";
                    dwReturn["VKKGLTBIS"] = "0";
                    dwReturn["VKKETAB"] = "0";
                    dwReturn["VKKBESTSB"] = "              ";
                    dwReturn["VKKAEDAT"] = "0";
                    dwReturn["VKKSACHBE"] = "        ";
                    dwReturn["VKKPRGRP"] = "RMB     ";
                    dwReturn["VKKPRGRPV"] = "        ";
                    dwReturn["VKKPRGRPZ"] = "        ";
                    dwReturn["VKKPRGRPSTD"] = "        ";
                    dwReturn["VKKPROJNR"] = "00000";
                    dwReturn["VKKVKART"] = "   ";
                    dwReturn["VKKKUNDNRST"] = "        ";
                    dwReturn["VKKABNGRPST"] = "   ";
                    dwReturn["VKKGLOBAL"] = " ";
                    dwReturn["VKKKOMENGE"] = "0";
                    dwReturn["VKKEINGET"] = "0";
                    dwReturn["VKKOFFEN"] = "0";
                    dwReturn["VKKEINGETOV"] = "0";
                    dwReturn["VKKEINGETPO"] = "0";
                    dwReturn["VKKCORQTY"] = "0";
                    dwReturn["VKKLIMGWO"] = "0";
                    dwReturn["VKKMEEH"] = "   ";
                    dwReturn["VKKMEEHGRP"] = " ";
                    dwReturn["VKKMEEHFKT"] = "000000000000";
                    dwReturn["VKKKOMENGET1"] = "0";
                    dwReturn["VKKKOMENGET2"] = "0";
                    dwReturn["VKKKOMENGET3"] = "0";
                    dwReturn["VKKKOMENGET4"] = "0";
                    dwReturn["VKKEINTT1"] = "0";
                    dwReturn["VKKEINTT2"] = "0";
                    dwReturn["VKKEINTT3"] = "0";
                    dwReturn["VKKEINTT4"] = "0";
                    dwReturn["VKKOFFENT1"] = "0";
                    dwReturn["VKKOFFENT2"] = "0";
                    dwReturn["VKKOFFENT3"] = "0";
                    dwReturn["VKKOFFENT4"] = "0";
                    dwReturn["VKKEINTTOV1"] = "0";
                    dwReturn["VKKEINTTOV2"] = "0";
                    dwReturn["VKKEINTTOV3"] = "0";
                    dwReturn["VKKEINTTOV4"] = "0";
                    dwReturn["VKKEINTTPO1"] = "0";
                    dwReturn["VKKEINTTPO2"] = "0";
                    dwReturn["VKKEINTTPO3"] = "0";
                    dwReturn["VKKEINTTPO4"] = "0";
                    dwReturn["VKKCORQTYT1"] = "0";
                    dwReturn["VKKCORQTYT2"] = "0";
                    dwReturn["VKKCORQTYT3"] = "0";
                    dwReturn["VKKCORQTYT4"] = "0";
                    dwReturn["VKKLIMGWOT1"] = "0";
                    dwReturn["VKKLIMGWOT2"] = "0";
                    dwReturn["VKKLIMGWOT3"] = "0";
                    dwReturn["VKKLIMGWOT4"] = "0";
                    dwReturn["VKKRSTBEZ"] = "      ";
                    dwReturn["VKKOPTION"] = " ";
                    dwReturn["VKKOPTANBIS"] = "0";
                    dwReturn["VKKOPTANAM"] = "0";
                    dwReturn["VKKDECKPROZ"] = "1000";
                    dwReturn["VKKWDECKDAT"] = " ";
                    dwReturn["VKKUEBEINT"] = "0";
                    dwReturn["VKKMINBEST"] = "0";
                    dwReturn["VKKMAXBEST"] = "0";
                    dwReturn["VKKSCHRAST"] = " ";
                    dwReturn["VKKGESMENGE1"] = "0";
                    dwReturn["VKKGESMENGE2"] = "0";
                    dwReturn["VKKGESMENGE3"] = "0";
                    dwReturn["VKKGESMENGE4"] = "0";
                    dwReturn["VKKGESWERT"] = "0";
                    dwReturn["VKKCOVPRC"] = "1000";
                    dwReturn["VKKAKKREDNR"] = "                    ";
                    dwReturn["VKKGESSTA"] = "  ";
                    dwReturn["VKKKDSTA"] = "10";
                    dwReturn["VKKAUFSTA"] = "20";
                    dwReturn["VKKPOSSTA"] = "30";
                    dwReturn["VKKSTA4"] = "40";
                    dwReturn["VKKKURS"] = "0010000";
                    dwReturn["VKKBETRAG"] = "0001";
                    dwReturn["VKKVKURS"] = "0000000";
                    dwReturn["VKKVBETRAG"] = "0000";
                    dwReturn["VKKSCHWPLU"] = "0";
                    dwReturn["VKKSCHWMIN"] = "0";
                    dwReturn["VKKHWAEHRSL"] = "RMB";
                    dwReturn["VKKHEUROKURS"] = "0";
                    dwReturn["VKKHEUROKURSVK"] = " ";
                    dwReturn["VKKFEUROKURS"] = "0";
                    dwReturn["VKKFEUROKURSVK"] = " ";
                    dwReturn["VKKALTWAEHR"] = "   ";
                    dwReturn["VKKALTWAEHRF"] = "0";
                    dwReturn["VKKVALUTA"] = "000";
                    dwReturn["VKKVALDAT"] = "0";
                    dwReturn["VKKWAEHRSL"] = "RMB";
                    dwReturn["VKKZAHLBED"] = "300";
                    dwReturn["VKKEKON"] = "        ";
                    dwReturn["VKKKDVKL"] = "   ";
                    dwReturn["VKKLIEFBED"] = "   ";
                    dwReturn["VKKLANDU"] = "   ";
                    dwReturn["VKKPLZU"] = "            ";
                    dwReturn["VKKORTU"] = "                                        ";
                    dwReturn["VKKBZU"] = "  ";
                    dwReturn["VKKBZBEZU"] = "             ";
                    dwReturn["VKKCOUNTYU"] = "    ";
                    dwReturn["VKKCITYU"] = "    ";
                    dwReturn["VKKLIEFKOMP"] = "N";
                    dwReturn["VKKVERSART"] = "   ";
                    dwReturn["VKKSPED"] = "   ";
                    dwReturn["VKKZUSATZ"] = "                                                            ";
                    dwReturn["VKKDRBEST"] = "N";
                    dwReturn["VKKBSTDAT"] = "0";
                    dwReturn["VKKANGETEXT"] = " ";
                    dwReturn["VKKANGEWIE"] = "0";
                    dwReturn["VKKBESTTEXT"] = " ";
                    dwReturn["VKKBESTWIE"] = "0";
                    dwReturn["VKKLIEFTEXT"] = " ";
                    dwReturn["VKKLIEFWIE"] = "0";
                    dwReturn["VKKRECHTEXT"] = " ";
                    dwReturn["VKKRECHWIE"] = "0";
                    dwReturn["VKKLVORTEXT"] = " ";
                    dwReturn["VKKLVORWIE"] = "0";
                    dwReturn["VKKIVVTTEXT"] = " ";
                    dwReturn["VKKIVVTWIE"] = "0";
                    dwReturn["VKKIVDITEXT"] = " ";
                    dwReturn["VKKIVDIWIE"] = "0";
                    dwReturn["VKKAGT"] = "        ";
                    dwReturn["VKKANGEALLG"] = "   ";
                    dwReturn["VKKBESTALLG"] = "   ";
                    dwReturn["VKKLIEFALLG"] = "   ";
                    dwReturn["VKKRECHALLG"] = "   ";
                    dwReturn["VKKLVORALLG"] = "   ";
                    dwReturn["VKKIVVTALLG"] = "   ";
                    dwReturn["VKKIVDIALLG"] = "   ";
                    dwReturn["VKKANL1TXT"] = "   ";
                    dwReturn["VKKANL2TXT"] = "   ";
                    dwReturn["VKKANL3TXT"] = "   ";
                    dwReturn["VKKDBLATT"] = " ";
                    dwReturn["VKKTBRIEF"] = " ";
                    dwReturn["VKKARTBILD"] = " ";
                    dwReturn["VKKFORMAT"] = " ";
                    dwReturn["VKKZEUGNIS"] = " ";
                    dwReturn["VKKRES1"] = " ";
                    dwReturn["VKKRES2"] = " ";
                    dwReturn["VKKVKZUABVH"] = " ";
                    dwReturn["VKKVKZUADR"] = " ";
                    dwReturn["VKKKZPRNEU"] = "N";
                    dwReturn["VKKKZFRNEU"] = "N";
                    dwReturn["VKKVAEAKZ"] = "J";
                    dwReturn["VKKMUKRS"] = "  ";
                    dwReturn["VKKMULFD"] = "000000";
                    dwReturn["VKKMUPOS"] = "000";
                    dwReturn["VKKCPKRS"] = "  ";
                    dwReturn["VKKCPLFD"] = "000000";
                    dwReturn["VKKCPPOS"] = "000";
                    dwReturn["VKKEDIKZ"] = " ";
                    dwReturn["VKKKOMMNR"] = "                    ";
                    dwReturn["VKKEDIDAT"] = "0";
                    dwReturn["VKKEDIZEIT"] = "0";
                    dwReturn["VKKABSAUFART"] = "  ";
                    dwReturn["VKKARCHKZ"] = " ";
                    dwReturn["VKKARCHDAT"] = "00000000";
                    dwReturn["VKKARCHBEL"] = "00000000";
                    dwReturn["VKKOPITEM"] = "          ";
                    dwReturn["VKKABSCHR"] = "0000";
                    dwReturn["VKKSFEUCHTE"] = "0000";
                    dwReturn["VKKAFEUCHTE"] = "0000";
                    dwReturn["VKKFEUKZ"] = " ";
                    dwReturn["VKKABRKZ"] = " ";
                    dwReturn["VKKVTYP"] = " ";
                    dwReturn["VKKEXMANDANT"] = "  ";
                    dwReturn["VKKWEGBINICH"] = " ";
                    dwReturn["VKKOFFNEU"] = "00000000";
                    dwReturn["VKKINDEXNA1"] = "      ";
                    dwReturn["VKKINDEXBA1"] = "0";
                    dwReturn["VKKINDEXHS1"] = "0";
                    dwReturn["VKKINDEXNA2"] = "      ";
                    dwReturn["VKKINDEXBA2"] = "0";
                    dwReturn["VKKINDEXHS2"] = "0";
                    dwReturn["VKKINDEXNA3"] = "      ";
                    dwReturn["VKKINDEXBA3"] = "0";
                    dwReturn["VKKINDEXHS3"] = "0";
                    dwReturn["VKKHUELBE"] = " ";
                    dwReturn["VKKRATIFI"] = " ";
                    dwReturn["VKKMU1ANZ"] = "0";
                    dwReturn["VKKMU1GR"] = "0";
                    dwReturn["VKKMU1ME"] = "   ";
                    dwReturn["VKKMU1PROMG"] = "0";
                    dwReturn["VKKMU2ANZ"] = "0";
                    dwReturn["VKKMU2GR"] = "0";
                    dwReturn["VKKMU2ME"] = "   ";
                    dwReturn["VKKMU2PROMG"] = "0";
                    dwReturn["VKKSPARTE"] = "  ";
                    dwReturn["VKKEINSATZG"] = "    ";
                    dwReturn["VKKVERWEND"] = "    ";
                    dwReturn["VKKERL"] = " ";
                    dwReturn["VKKRD"] = "  ";
                    dwReturn["VKKFILLER"] = "                                             ";
                    #endregion
                    break;
                case "JLT":
                    break;
                default:

                    break;
            }
            INTEXDBC.MapData(IsConvert, ref dwReturn, dwInput);
            return SResult;
        }

        public void DeleteVKKOPF(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "DELETE FROM VKKOPF  WHERE  VKKMANDANT=:VKKMANDANT: AND (VKKSA='  ' OR VKKSA='IN') AND VKKAUFKRS=:VKKAUFKRS: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 1:
                    or1.CommandText = "DELETE FROM VKKOPF  WHERE  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                 
                default:
                    break;
            }
            Connect2Proxy(or1);
        }
        public void DVKK02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "DELETE FROM VKKOPF WHERE VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: AND"
                +" NOT EXISTS (SELECT 1 FROM VKPOS WHERE VKKMANDANT=VKPMANDANT AND VKKAUFKRS=VKPAUFKRS AND VKPAUFLFD=VKKAUFLFD)";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void SaveVKKOPF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet Result = new DataSet();
            DataTable tbLocal = null;

            bool flgExist = false;
            Result = QueryVKKOPF(dwData);
            if (Result.Tables.Count > 0)
            {
                tbLocal = Result.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                }
            }

            if (!flgExist)
            {
                InsertVKKOPF(dwData, ITXDBVERSION);
            }
            switch (ITXDBVERSION)
            {
                default:
                    UpdateVKKOPF(dwData, ITXDBVERSION, 1);
                    break;
                case "YGR":
                case "YCC":
                case "TST":
                    UpdateVKKOPF(dwData, ITXDBVERSION, 2);
                    break;
            }
        }

        public void InsertVKKOPF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            dwData["VKKNEUDAT"] = date;
            dwData["VKKNEUBEN"] = app.User;
            or1 = OracleDB.CreateCommand();
            switch (app.company)
            {
                case "50.24":
                    or1.CommandText = "INSERT INTO VKKOPF(VKKMANDANT, VKKSA, VKKAUFKRS, VKKAUFLFD, VKKAENDST, VKKAENDZL, VKKAENDBEN, VKKAENDDAT, VKKNEUBEN, VKKNEUDAT, VKKAESTAT, VKKAUFART, VKKKUNDNR, VKKVB, VKKVG, VKKADRSL, VKKVERBNR, VKKZENTR, VKKZENTRR, VKKKREDKDNR, VKKKDARTBEZ, VKKORDER, VKKANSPRECH, VKKANSPZUS, VKKBESTNR, VKKBESTDAT, VKKGLTVON, VKKGLTBIS, VKKETAB, VKKBESTSB, VKKAEDAT, VKKSACHBE, VKKPRGRP, VKKPRGRPV, VKKPRGRPZ, VKKPRGRPSTD, VKKPROJNR, VKKVKART, VKKKUNDNRST, VKKABNGRPST, VKKGLOBAL, VKKKOMENGE, VKKEINGET, VKKOFFEN, VKKEINGETOV, VKKEINGETPO, VKKCORQTY, VKKLIMGWO, VKKMEEH, VKKMEEHGRP, VKKMEEHFKT, VKKKOMENGET1, VKKKOMENGET2, VKKKOMENGET3, VKKKOMENGET4, VKKEINTT1, VKKEINTT2, VKKEINTT3, VKKEINTT4, VKKOFFENT1, VKKOFFENT2, VKKOFFENT3, VKKOFFENT4, VKKEINTTOV1, VKKEINTTOV2, VKKEINTTOV3, VKKEINTTOV4, VKKEINTTPO1, VKKEINTTPO2, VKKEINTTPO3, VKKEINTTPO4, VKKCORQTYT1, VKKCORQTYT2, VKKCORQTYT3, VKKCORQTYT4, VKKLIMGWOT1, VKKLIMGWOT2, VKKLIMGWOT3, VKKLIMGWOT4, VKKRSTBEZ, VKKOPTION, VKKOPTANBIS, VKKOPTANAM, VKKDECKPROZ, VKKWDECKDAT, VKKUEBEINT, VKKMINBEST, VKKMAXBEST, VKKSCHRAST, VKKGESMENGE1, VKKGESMENGE2, VKKGESMENGE3, VKKGESMENGE4, VKKGESWERT, VKKCOVPRC, VKKAKKREDNR, VKKGESSTA, VKKKDSTA, VKKAUFSTA, VKKPOSSTA, VKKSTA4, VKKKURS, VKKBETRAG, VKKVKURS, VKKVBETRAG, VKKSCHWPLU, VKKSCHWMIN, VKKHWAEHRSL, VKKHEUROKURS, VKKHEUROKURSVK, VKKFEUROKURS, VKKFEUROKURSVK, VKKALTWAEHR, VKKALTWAEHRF, VKKVALUTA, VKKVALDAT, VKKWAEHRSL, VKKZAHLBED, VKKEKON, VKKKDVKL, VKKLIEFBED, VKKLANDU, VKKPLZU, VKKORTU, VKKBZU, VKKBZBEZU, VKKCOUNTYU, VKKCITYU, VKKLIEFKOMP, VKKVERSART, VKKSPED, VKKZUSATZ, VKKDRBEST, VKKBSTDAT, VKKANGETEXT, VKKANGEWIE, VKKBESTTEXT, VKKBESTWIE, VKKLIEFTEXT, VKKLIEFWIE, VKKRECHTEXT, VKKRECHWIE, VKKLVORTEXT, VKKLVORWIE, VKKIVVTTEXT, VKKIVVTWIE, VKKIVDITEXT, VKKIVDIWIE, VKKAGT, VKKANGEALLG, VKKBESTALLG, VKKLIEFALLG, VKKRECHALLG, VKKLVORALLG, VKKIVVTALLG, VKKIVDIALLG, VKKANL1TXT, VKKANL2TXT, VKKANL3TXT, VKKDBLATT, VKKTBRIEF, VKKARTBILD, VKKFORMAT, VKKZEUGNIS, VKKRES1, VKKRES2, VKKVKZUABVH, VKKVKZUADR, VKKKZPRNEU, VKKKZFRNEU, VKKVAEAKZ, VKKMUKRS, VKKMULFD, VKKMUPOS, VKKCPKRS, VKKCPLFD, VKKCPPOS, VKKEDIKZ, VKKKOMMNR, VKKEDIDAT, VKKEDIZEIT, VKKABSAUFART, VKKARCHKZ, VKKARCHDAT, VKKARCHBEL, VKKOPITEM, VKKABSCHR, VKKSFEUCHTE, VKKAFEUCHTE, VKKFEUKZ, VKKABRKZ, VKKVTYP, VKKEXMANDANT, VKKWEGBINICH, VKKOFFNEU, VKKINDEXNA1, VKKINDEXBA1, VKKINDEXHS1, VKKINDEXNA2, VKKINDEXBA2, VKKINDEXHS2, VKKINDEXNA3, VKKINDEXBA3, VKKINDEXHS3, VKKHUELBE, VKKRATIFI, VKKMU1ANZ, VKKMU1GR, VKKMU1ME, VKKMU1PROMG, VKKMU2ANZ, VKKMU2GR, VKKMU2ME, VKKMU2PROMG, VKKFILLER)"
                        + " VALUES (:VKKMANDANT:, '  ', :VKKAUFKRS:, :VKKAUFLFD:, '000', '012', 'SUNLV   ', 20130219, 'SUNLV   ', 20130104, 'S', 'NA', '00000200', 'RMB', '   ', '        ', '        ', '        ', ' ', '00000200', 'K', 'MAIL', '        ', '                          ', '               ', 20130219, 0, 0, 0, '              ', 20100224, 'BDE     ', 'SA      ', '        ', '        ', 'SA      ', '00000', '   ', '        ', '   ', ' ', 0, 0, 0, 0, 0, 0, 0, '   ', ' ', '000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', 0, 0, 1000, ' ', 0, 0, 0, ' ', 6, 303, 486, 84, 3896, 0, '                    ', '  ', '10', '20', '30', '40', '0010000', '0001', '0000000', '0000', 0, 0, 'RMB', 0, ' ', 0, ' ', '   ', 0, '000', 0, 'RMB', '30V', '        ', '   ', 'EXW', 'CN ', '42116       ', 'ZHANGJIAGANG                            ', '1 ', 'JIANGSU      ', '    ', '    ', 'N', 'LDY', 'HWD', '                                                            ', 'J', 0, ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', '        ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'N', 'N', 'J', '  ', '000000', '000', '  ', '000000', '000', ' ', '                    ', 0, 0, '  ', ' ', '00000000', '00000000', 'C0100227  ', '0000', '0000', '0000', ' ', ' ', ' ', '  ', ' ', '00000000', '      ', 0, 0, '      ', 0, 0, '      ', 0, 0, ' ', ' ', 0, 0, ' ', 0, 0, 0, ' ', 0, '                                                              ')";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "50.25":
                    or1.CommandText = "INSERT INTO VKKOPF(VKKMANDANT, VKKSA, VKKAUFKRS, VKKAUFLFD, VKKAENDST, VKKAENDZL, VKKAENDBEN, VKKAENDDAT, VKKNEUBEN, VKKNEUDAT, VKKAESTAT, VKKAUFART, VKKKUNDNR, VKKVB, VKKVG, VKKADRSL, VKKVERBNR, VKKZENTR, VKKZENTRR, VKKKREDKDNR, VKKKDARTBEZ, VKKORDER, VKKANSPRECH, VKKANSPZUS, VKKBESTNR, VKKBESTDAT, VKKGLTVON, VKKGLTBIS, VKKETAB, VKKBESTSB, VKKAEDAT, VKKSACHBE, VKKPRGRP, VKKPRGRPV, VKKPRGRPZ, VKKPRGRPSTD, VKKPROJNR, VKKVKART, VKKKUNDNRST, VKKABNGRPST, VKKGLOBAL, VKKKOMENGE, VKKEINGET, VKKOFFEN, VKKEINGETOV, VKKEINGETPO, VKKCORQTY, VKKLIMGWO, VKKMEEH, VKKMEEHGRP, VKKMEEHFKT, VKKKOMENGET1, VKKKOMENGET2, VKKKOMENGET3, VKKKOMENGET4, VKKEINTT1, VKKEINTT2, VKKEINTT3, VKKEINTT4, VKKOFFENT1, VKKOFFENT2, VKKOFFENT3, VKKOFFENT4, VKKEINTTOV1, VKKEINTTOV2, VKKEINTTOV3, VKKEINTTOV4, VKKEINTTPO1, VKKEINTTPO2, VKKEINTTPO3, VKKEINTTPO4, VKKCORQTYT1, VKKCORQTYT2, VKKCORQTYT3, VKKCORQTYT4, VKKLIMGWOT1, VKKLIMGWOT2, VKKLIMGWOT3, VKKLIMGWOT4, VKKRSTBEZ, VKKOPTION, VKKOPTANBIS, VKKOPTANAM, VKKDECKPROZ, VKKWDECKDAT, VKKUEBEINT, VKKMINBEST, VKKMAXBEST, VKKSCHRAST, VKKGESMENGE1, VKKGESMENGE2, VKKGESMENGE3, VKKGESMENGE4, VKKGESWERT, VKKCOVPRC, VKKAKKREDNR, VKKGESSTA, VKKKDSTA, VKKAUFSTA, VKKPOSSTA, VKKSTA4, VKKKURS, VKKBETRAG, VKKVKURS, VKKVBETRAG, VKKSCHWPLU, VKKSCHWMIN, VKKHWAEHRSL, VKKHEUROKURS, VKKHEUROKURSVK, VKKFEUROKURS, VKKFEUROKURSVK, VKKALTWAEHR, VKKALTWAEHRF, VKKVALUTA, VKKVALDAT, VKKWAEHRSL, VKKZAHLBED, VKKEKON, VKKKDVKL, VKKLIEFBED, VKKLANDU, VKKPLZU, VKKORTU, VKKBZU, VKKBZBEZU, VKKCOUNTYU, VKKCITYU, VKKLIEFKOMP, VKKVERSART, VKKSPED, VKKZUSATZ, VKKDRBEST, VKKBSTDAT, VKKANGETEXT, VKKANGEWIE, VKKBESTTEXT, VKKBESTWIE, VKKLIEFTEXT, VKKLIEFWIE, VKKRECHTEXT, VKKRECHWIE, VKKLVORTEXT, VKKLVORWIE, VKKIVVTTEXT, VKKIVVTWIE, VKKIVDITEXT, VKKIVDIWIE, VKKAGT, VKKANGEALLG, VKKBESTALLG, VKKLIEFALLG, VKKRECHALLG, VKKLVORALLG, VKKIVVTALLG, VKKIVDIALLG, VKKANL1TXT, VKKANL2TXT, VKKANL3TXT, VKKDBLATT, VKKTBRIEF, VKKARTBILD, VKKFORMAT, VKKZEUGNIS, VKKRES1, VKKRES2, VKKVKZUABVH, VKKVKZUADR, VKKKZPRNEU, VKKKZFRNEU, VKKVAEAKZ, VKKMUKRS, VKKMULFD, VKKMUPOS, VKKCPKRS, VKKCPLFD, VKKCPPOS, VKKEDIKZ, VKKKOMMNR, VKKEDIDAT, VKKEDIZEIT, VKKABSAUFART, VKKARCHKZ, VKKARCHDAT, VKKARCHBEL, VKKOPITEM, VKKABSCHR, VKKSFEUCHTE, VKKAFEUCHTE, VKKFEUKZ, VKKABRKZ, VKKVTYP, VKKEXMANDANT, VKKWEGBINICH, VKKOFFNEU, VKKINDEXNA1, VKKINDEXBA1, VKKINDEXHS1, VKKINDEXNA2, VKKINDEXBA2, VKKINDEXHS2, VKKINDEXNA3, VKKINDEXBA3, VKKINDEXHS3, VKKHUELBE, VKKRATIFI, VKKMU1ANZ, VKKMU1GR, VKKMU1ME, VKKMU1PROMG, VKKMU2ANZ, VKKMU2GR, VKKMU2ME, VKKMU2PROMG, VKKSPARTE, VKKEINSATZG, VKKVERWEND, VKKERL, VKKFILLER)"
                        + " VALUES (:VKKMANDANT:, '  ', :VKKAUFKRS:, :VKKAUFLFD:, '000', '012', 'SUNLV   ', 20130219, 'SUNLV   ', 20130104, 'S', 'NA', '00000200', 'RMB', '   ', '        ', '        ', '        ', ' ', '00000200', 'K', 'MAIL', '        ', '                          ', '               ', 20130219, 0, 0, 0, '              ', 20100224, 'BDE     ', 'SA      ', '        ', '        ', 'SA      ', '00000', '   ', '        ', '   ', ' ', 0, 0, 0, 0, 0, 0, 0, '   ', ' ', '000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '      ', ' ', 0, 0, 1000, ' ', 0, 0, 0, ' ', 6, 303, 486, 84, 3896, 0, '                    ', '  ', '10', '20', '30', '40', '0010000', '0001', '0000000', '0000', 0, 0, 'RMB', 0, ' ', 0, ' ', '   ', 0, '000', 0, 'RMB', '30V', '        ', '   ', 'EXW', 'CN ', '42116       ', 'ZHANGJIAGANG                            ', '1 ', 'JIANGSU      ', '    ', '    ', 'N', 'LDY', 'HWD', '                                                            ', 'J', 0, ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', ' ', '0', '        ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', '   ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'N', 'N', 'J', '  ', '000000', '000', '  ', '000000', '000', ' ', '                    ', 0, 0, '  ', ' ', '00000000', '00000000', 'C0100227  ', '0000', '0000', '0000', ' ', ' ', ' ', '  ', ' ', '00000000', '      ', 0, 0, '      ', 0, 0, '      ', 0, 0, ' ', ' ', 0, 0, '   ', 0, 0, 0, '   ', 0, '  ', '    ', '    ', ' ', '                                               ')";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                case "YGR":
                case "SXN":
                case "TST":
                case "UBT":
                    or1.CommandText = "INSERT INTO VKKOPF ( VKKMANDANT,VKKSA,VKKAUFKRS,VKKAUFLFD,VKKAENDST,VKKAENDZL,VKKAENDBEN,VKKAENDDAT,VKKNEUBEN,VKKNEUDAT,VKKAESTAT,VKKAUFART,VKKKUNDNR,VKKVB,VKKVG,VKKADRSL,VKKVERBNR,VKKZENTR,VKKZENTRR,VKKKREDKDNR,VKKKDARTBEZ,VKKORDER,VKKANSPRECH,VKKANSPZUS,VKKBESTNR,VKKBESTDAT,VKKGLTVON,VKKGLTBIS,VKKETAB,VKKBESTSB,VKKAEDAT,VKKSACHBE,VKKPRGRP,VKKPRGRPV,VKKPRGRPZ,VKKPRGRPSTD,VKKPROJNR,VKKVKART,VKKKUNDNRST,VKKABNGRPST,VKKGLOBAL,VKKKOMENGE,VKKEINGET,VKKOFFEN,VKKEINGETOV,VKKEINGETPO,VKKCORQTY,VKKLIMGWO,VKKMEEH,VKKMEEHGRP,VKKMEEHFKT,VKKKOMENGET1,VKKKOMENGET2,VKKKOMENGET3,VKKKOMENGET4,VKKEINTT1,VKKEINTT2,VKKEINTT3,VKKEINTT4,VKKOFFENT1,VKKOFFENT2,VKKOFFENT3,VKKOFFENT4,VKKEINTTOV1,VKKEINTTOV2,VKKEINTTOV3,VKKEINTTOV4,VKKEINTTPO1,VKKEINTTPO2,VKKEINTTPO3,VKKEINTTPO4,VKKCORQTYT1,VKKCORQTYT2,VKKCORQTYT3,VKKCORQTYT4,VKKLIMGWOT1,VKKLIMGWOT2,VKKLIMGWOT3,VKKLIMGWOT4,VKKRSTBEZ,VKKOPTION,VKKOPTANBIS,VKKOPTANAM,VKKDECKPROZ,VKKWDECKDAT,VKKUEBEINT,VKKMINBEST,VKKMAXBEST,VKKSCHRAST,VKKGESMENGE1,VKKGESMENGE2,VKKGESMENGE3,VKKGESMENGE4,VKKGESWERT,VKKCOVPRC,VKKAKKREDNR,VKKGESSTA,VKKKDSTA,VKKAUFSTA,VKKPOSSTA,VKKSTA4,VKKKURS,VKKBETRAG,VKKVKURS,VKKVBETRAG,VKKSCHWPLU,VKKSCHWMIN,VKKHWAEHRSL,VKKHEUROKURS,VKKHEUROKURSVK,VKKFEUROKURS,VKKFEUROKURSVK,VKKALTWAEHR,VKKALTWAEHRF,VKKVALUTA,VKKVALDAT,VKKWAEHRSL,VKKZAHLBED,VKKEKON,VKKKDVKL,VKKLIEFBED,VKKLANDU,VKKPLZU,VKKORTU,VKKBZU,VKKBZBEZU,VKKCOUNTYU,VKKCITYU,VKKLIEFKOMP,VKKVERSART,VKKSPED,VKKZUSATZ,VKKDRBEST,VKKBSTDAT,VKKANGETEXT,VKKANGEWIE,VKKBESTTEXT,VKKBESTWIE,VKKLIEFTEXT,VKKLIEFWIE,VKKRECHTEXT,VKKRECHWIE,VKKLVORTEXT,VKKLVORWIE,VKKIVVTTEXT,VKKIVVTWIE,VKKIVDITEXT,VKKIVDIWIE,VKKAGT,VKKANGEALLG,VKKBESTALLG,VKKLIEFALLG,VKKRECHALLG,VKKLVORALLG,VKKIVVTALLG,VKKIVDIALLG,VKKANL1TXT,VKKANL2TXT,VKKANL3TXT,VKKDBLATT,VKKTBRIEF,VKKARTBILD,VKKFORMAT,VKKZEUGNIS,VKKRES1,VKKRES2,VKKVKZUABVH,VKKVKZUADR,VKKKZPRNEU,VKKKZFRNEU,VKKVAEAKZ,VKKMUKRS,VKKMULFD,VKKMUPOS,VKKCPKRS,VKKCPLFD,VKKCPPOS,VKKEDIKZ,VKKKOMMNR,VKKEDIDAT,VKKEDIZEIT,VKKABSAUFART,VKKARCHKZ,VKKARCHDAT,VKKARCHBEL,VKKOPITEM,VKKABSCHR,VKKSFEUCHTE,VKKAFEUCHTE,VKKFEUKZ,VKKABRKZ,VKKVTYP,VKKEXMANDANT,VKKWEGBINICH,VKKOFFNEU,VKKINDEXNA1,VKKINDEXBA1,VKKINDEXHS1,VKKINDEXNA2,VKKINDEXBA2,VKKINDEXHS2,VKKINDEXNA3,VKKINDEXBA3,VKKINDEXHS3,VKKHUELBE,VKKRATIFI,VKKMU1ANZ,VKKMU1GR,VKKMU1ME,VKKMU1PROMG,VKKMU2ANZ,VKKMU2GR,VKKMU2ME,VKKMU2PROMG,VKKSPARTE,VKKEINSATZG,VKKVERWEND,VKKERL,VKKRD,VKKFILLER)"
                         + " SELECT :VKKMANDANT:,:VKKSA:,:VKKAUFKRS:,:VKKAUFLFD:,:VKKAENDST:,:VKKAENDZL:,:VKKAENDBEN:,:VKKAENDDAT:,:VKKNEUBEN:,:VKKNEUDAT:,:VKKAESTAT:,:VKKAUFART:,:VKKKUNDNR:,:VKKVB:,:VKKVG:,:VKKADRSL:,:VKKVERBNR:,:VKKZENTR:,:VKKZENTRR:,:VKKKREDKDNR:,:VKKKDARTBEZ:,:VKKORDER:,:VKKANSPRECH:,:VKKANSPZUS:,:VKKBESTNR:,:VKKBESTDAT:,:VKKGLTVON:,:VKKGLTBIS:,:VKKETAB:,:VKKBESTSB:,:VKKAEDAT:,:VKKSACHBE:,:VKKPRGRP:,:VKKPRGRPV:,:VKKPRGRPZ:,:VKKPRGRPSTD:,:VKKPROJNR:,:VKKVKART:,:VKKKUNDNRST:,:VKKABNGRPST:,:VKKGLOBAL:,:VKKKOMENGE:,:VKKEINGET:,:VKKOFFEN:,:VKKEINGETOV:,:VKKEINGETPO:,:VKKCORQTY:,:VKKLIMGWO:,:VKKMEEH:,:VKKMEEHGRP:,:VKKMEEHFKT:,:VKKKOMENGET1:,:VKKKOMENGET2:,:VKKKOMENGET3:,:VKKKOMENGET4:,:VKKEINTT1:,:VKKEINTT2:,:VKKEINTT3:,:VKKEINTT4:,:VKKOFFENT1:,:VKKOFFENT2:,:VKKOFFENT3:,:VKKOFFENT4:,:VKKEINTTOV1:,:VKKEINTTOV2:,:VKKEINTTOV3:,:VKKEINTTOV4:,:VKKEINTTPO1:,:VKKEINTTPO2:,:VKKEINTTPO3:,:VKKEINTTPO4:,:VKKCORQTYT1:,:VKKCORQTYT2:,:VKKCORQTYT3:,:VKKCORQTYT4:,:VKKLIMGWOT1:,:VKKLIMGWOT2:,:VKKLIMGWOT3:,:VKKLIMGWOT4:,:VKKRSTBEZ:,:VKKOPTION:,:VKKOPTANBIS:,:VKKOPTANAM:,:VKKDECKPROZ:,:VKKWDECKDAT:,:VKKUEBEINT:,:VKKMINBEST:,:VKKMAXBEST:,:VKKSCHRAST:,:VKKGESMENGE1:,:VKKGESMENGE2:,:VKKGESMENGE3:,:VKKGESMENGE4:,:VKKGESWERT:,:VKKCOVPRC:,:VKKAKKREDNR:,:VKKGESSTA:,:VKKKDSTA:,:VKKAUFSTA:,:VKKPOSSTA:,:VKKSTA4:,:VKKKURS:,:VKKBETRAG:,:VKKVKURS:,:VKKVBETRAG:,:VKKSCHWPLU:,:VKKSCHWMIN:,:VKKHWAEHRSL:,:VKKHEUROKURS:,:VKKHEUROKURSVK:,:VKKFEUROKURS:,:VKKFEUROKURSVK:,:VKKALTWAEHR:,:VKKALTWAEHRF:,:VKKVALUTA:,:VKKVALDAT:,:VKKWAEHRSL:,:VKKZAHLBED:,:VKKEKON:,:VKKKDVKL:,:VKKLIEFBED:,:VKKLANDU:,:VKKPLZU:,:VKKORTU:,:VKKBZU:,:VKKBZBEZU:,:VKKCOUNTYU:,:VKKCITYU:,:VKKLIEFKOMP:,:VKKVERSART:,:VKKSPED:,:VKKZUSATZ:,:VKKDRBEST:,:VKKBSTDAT:,:VKKANGETEXT:,:VKKANGEWIE:,:VKKBESTTEXT:,:VKKBESTWIE:,:VKKLIEFTEXT:,:VKKLIEFWIE:,:VKKRECHTEXT:,:VKKRECHWIE:,:VKKLVORTEXT:,:VKKLVORWIE:,:VKKIVVTTEXT:,:VKKIVVTWIE:,:VKKIVDITEXT:,:VKKIVDIWIE:,:VKKAGT:,:VKKANGEALLG:,:VKKBESTALLG:,:VKKLIEFALLG:,:VKKRECHALLG:,:VKKLVORALLG:,:VKKIVVTALLG:,:VKKIVDIALLG:,:VKKANL1TXT:,:VKKANL2TXT:,:VKKANL3TXT:,:VKKDBLATT:,:VKKTBRIEF:,:VKKARTBILD:,:VKKFORMAT:,:VKKZEUGNIS:,:VKKRES1:,:VKKRES2:,:VKKVKZUABVH:,:VKKVKZUADR:,:VKKKZPRNEU:,:VKKKZFRNEU:,:VKKVAEAKZ:,:VKKMUKRS:,:VKKMULFD:,:VKKMUPOS:,:VKKCPKRS:,:VKKCPLFD:,:VKKCPPOS:,:VKKEDIKZ:,:VKKKOMMNR:,:VKKEDIDAT:,:VKKEDIZEIT:,:VKKABSAUFART:,:VKKARCHKZ:,:VKKARCHDAT:,:VKKARCHBEL:,:VKKOPITEM:,:VKKABSCHR:,:VKKSFEUCHTE:,:VKKAFEUCHTE:,:VKKFEUKZ:,:VKKABRKZ:,:VKKVTYP:,:VKKEXMANDANT:,:VKKWEGBINICH:,:VKKOFFNEU:,:VKKINDEXNA1:,:VKKINDEXBA1:,:VKKINDEXHS1:,:VKKINDEXNA2:,:VKKINDEXBA2:,:VKKINDEXHS2:,:VKKINDEXNA3:,:VKKINDEXBA3:,:VKKINDEXHS3:,:VKKHUELBE:,:VKKRATIFI:,:VKKMU1ANZ:,:VKKMU1GR:,:VKKMU1ME:,:VKKMU1PROMG:,:VKKMU2ANZ:,:VKKMU2GR:,:VKKMU2ME:,:VKKMU2PROMG:,:VKKSPARTE:,:VKKEINSATZG:,:VKKVERWEND:,:VKKERL:,:VKKRD:,:VKKFILLER:"
                         + " FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM VKKOPF WHERE VKKMANDANT=:VKKMANDANT: AND VKKSA=:VKKSA: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: )";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "JLT":
                    or1.CommandText = "INSERT INTO VKKOPF ( VKKMANDANT,VKKSA,VKKAUFKRS,VKKAUFLFD,VKKAENDST,VKKAENDZL,VKKAENDBEN,VKKAENDDAT,VKKNEUBEN,VKKNEUDAT,VKKAESTAT,VKKAUFART,VKKKUNDNR,VKKVB,VKKVG,VKKADRSL,VKKVERBNR,VKKZENTR,VKKZENTRR,VKKKREDKDNR,VKKKDARTBEZ,VKKORDER,VKKANSPRECH,VKKANSPZUS,VKKBESTNR,VKKBESTDAT,VKKGLTVON,VKKGLTBIS,VKKETAB,VKKBESTSB,VKKAEDAT,VKKSACHBE,VKKPRGRP,VKKPRGRPV,VKKPRGRPZ,VKKPRGRPSTD,VKKPROJNR,VKKVKART,VKKKUNDNRST,VKKABNGRPST,VKKGLOBAL,VKKKOMENGE,VKKEINGET,VKKOFFEN,VKKEINGETOV,VKKEINGETPO,VKKCORQTY,VKKLIMGWO,VKKMEEH,VKKMEEHGRP,VKKMEEHFKT,VKKKOMENGET1,VKKKOMENGET2,VKKKOMENGET3,VKKKOMENGET4,VKKEINTT1,VKKEINTT2,VKKEINTT3,VKKEINTT4,VKKOFFENT1,VKKOFFENT2,VKKOFFENT3,VKKOFFENT4,VKKEINTTOV1,VKKEINTTOV2,VKKEINTTOV3,VKKEINTTOV4,VKKEINTTPO1,VKKEINTTPO2,VKKEINTTPO3,VKKEINTTPO4,VKKCORQTYT1,VKKCORQTYT2,VKKCORQTYT3,VKKCORQTYT4,VKKLIMGWOT1,VKKLIMGWOT2,VKKLIMGWOT3,VKKLIMGWOT4,VKKRSTBEZ,VKKOPTION,VKKOPTANBIS,VKKOPTANAM,VKKDECKPROZ,VKKWDECKDAT,VKKUEBEINT,VKKMINBEST,VKKMAXBEST,VKKSCHRAST,VKKGESMENGE1,VKKGESMENGE2,VKKGESMENGE3,VKKGESMENGE4,VKKGESWERT,VKKCOVPRC,VKKAKKREDNR,VKKGESSTA,VKKKDSTA,VKKAUFSTA,VKKPOSSTA,VKKSTA4,VKKKURS,VKKBETRAG,VKKVKURS,VKKVBETRAG,VKKSCHWPLU,VKKSCHWMIN,VKKHWAEHRSL,VKKHEUROKURS,VKKHEUROKURSVK,VKKFEUROKURS,VKKFEUROKURSVK,VKKALTWAEHR,VKKALTWAEHRF,VKKVALUTA,VKKVALDAT,VKKWAEHRSL,VKKZAHLBED,VKKEKON,VKKKDVKL,VKKLIEFBED,VKKLANDU,VKKPLZU,VKKORTU,VKKBZU,VKKBZBEZU,VKKCOUNTYU,VKKCITYU,VKKLIEFKOMP,VKKVERSART,VKKSPED,VKKZUSATZ,VKKDRBEST,VKKBSTDAT,VKKANGETEXT,VKKANGEWIE,VKKBESTTEXT,VKKBESTWIE,VKKLIEFTEXT,VKKLIEFWIE,VKKRECHTEXT,VKKRECHWIE,VKKLVORTEXT,VKKLVORWIE,VKKIVVTTEXT,VKKIVVTWIE,VKKIVDITEXT,VKKIVDIWIE,VKKAGT,VKKANGEALLG,VKKBESTALLG,VKKLIEFALLG,VKKRECHALLG,VKKLVORALLG,VKKIVVTALLG,VKKIVDIALLG,VKKANL1TXT,VKKANL2TXT,VKKANL3TXT,VKKDBLATT,VKKTBRIEF,VKKARTBILD,VKKFORMAT,VKKZEUGNIS,VKKRES1,VKKRES2,VKKVKZUABVH,VKKVKZUADR,VKKKZPRNEU,VKKKZFRNEU,VKKVAEAKZ,VKKMUKRS,VKKMULFD,VKKMUPOS,VKKCPKRS,VKKCPLFD,VKKCPPOS,VKKEDIKZ,VKKKOMMNR,VKKEDIDAT,VKKEDIZEIT,VKKABSAUFART,VKKARCHKZ,VKKARCHDAT,VKKARCHBEL,VKKOPITEM,VKKABSCHR,VKKSFEUCHTE,VKKAFEUCHTE,VKKFEUKZ,VKKABRKZ,VKKVTYP,VKKEXMANDANT,VKKWEGBINICH,VKKOFFNEU,VKKINDEXNA1,VKKINDEXBA1,VKKINDEXHS1,VKKINDEXNA2,VKKINDEXBA2,VKKINDEXHS2,VKKINDEXNA3,VKKINDEXBA3,VKKINDEXHS3,VKKHUELBE,VKKRATIFI,VKKMU1ANZ,VKKMU1GR,VKKMU1ME,VKKMU1PROMG,VKKMU2ANZ,VKKMU2GR,VKKMU2ME,VKKMU2PROMG,VKKSPARTE,VKKEINSATZG,VKKVERWEND,VKKERL,VKKRD,VKKFILLER)"
                    + " VALUES (:VKKMANDANT:,:VKKSA:,:VKKAUFKRS:,:VKKAUFLFD:,:VKKAENDST:,:VKKAENDZL:,:VKKAENDBEN:,:VKKAENDDAT:,:VKKNEUBEN:,:VKKNEUDAT:,:VKKAESTAT:,:VKKAUFART:,:VKKKUNDNR:,:VKKVB:,:VKKVG:,:VKKADRSL:,:VKKVERBNR:,:VKKZENTR:,:VKKZENTRR:,:VKKKREDKDNR:,:VKKKDARTBEZ:,:VKKORDER:,:VKKANSPRECH:,:VKKANSPZUS:,:VKKBESTNR:,:VKKBESTDAT:,:VKKGLTVON:,:VKKGLTBIS:,:VKKETAB:,:VKKBESTSB:,:VKKAEDAT:,:VKKSACHBE:,:VKKPRGRP:,:VKKPRGRPV:,:VKKPRGRPZ:,:VKKPRGRPSTD:,:VKKPROJNR:,:VKKVKART:,:VKKKUNDNRST:,:VKKABNGRPST:,:VKKGLOBAL:,:VKKKOMENGE:,:VKKEINGET:,:VKKOFFEN:,:VKKEINGETOV:,:VKKEINGETPO:,:VKKCORQTY:,:VKKLIMGWO:,:VKKMEEH:,:VKKMEEHGRP:,:VKKMEEHFKT:,:VKKKOMENGET1:,:VKKKOMENGET2:,:VKKKOMENGET3:,:VKKKOMENGET4:,:VKKEINTT1:,:VKKEINTT2:,:VKKEINTT3:,:VKKEINTT4:,:VKKOFFENT1:,:VKKOFFENT2:,:VKKOFFENT3:,:VKKOFFENT4:,:VKKEINTTOV1:,:VKKEINTTOV2:,:VKKEINTTOV3:,:VKKEINTTOV4:,:VKKEINTTPO1:,:VKKEINTTPO2:,:VKKEINTTPO3:,:VKKEINTTPO4:,:VKKCORQTYT1:,:VKKCORQTYT2:,:VKKCORQTYT3:,:VKKCORQTYT4:,:VKKLIMGWOT1:,:VKKLIMGWOT2:,:VKKLIMGWOT3:,:VKKLIMGWOT4:,:VKKRSTBEZ:,:VKKOPTION:,:VKKOPTANBIS:,:VKKOPTANAM:,:VKKDECKPROZ:,:VKKWDECKDAT:,:VKKUEBEINT:,:VKKMINBEST:,:VKKMAXBEST:,:VKKSCHRAST:,:VKKGESMENGE1:,:VKKGESMENGE2:,:VKKGESMENGE3:,:VKKGESMENGE4:,:VKKGESWERT:,:VKKCOVPRC:,:VKKAKKREDNR:,:VKKGESSTA:,:VKKKDSTA:,:VKKAUFSTA:,:VKKPOSSTA:,:VKKSTA4:,:VKKKURS:,:VKKBETRAG:,:VKKVKURS:,:VKKVBETRAG:,:VKKSCHWPLU:,:VKKSCHWMIN:,:VKKHWAEHRSL:,:VKKHEUROKURS:,:VKKHEUROKURSVK:,:VKKFEUROKURS:,:VKKFEUROKURSVK:,:VKKALTWAEHR:,:VKKALTWAEHRF:,:VKKVALUTA:,:VKKVALDAT:,:VKKWAEHRSL:,:VKKZAHLBED:,:VKKEKON:,:VKKKDVKL:,:VKKLIEFBED:,:VKKLANDU:,:VKKPLZU:,:VKKORTU:,:VKKBZU:,:VKKBZBEZU:,:VKKCOUNTYU:,:VKKCITYU:,:VKKLIEFKOMP:,:VKKVERSART:,:VKKSPED:,:VKKZUSATZ:,:VKKDRBEST:,:VKKBSTDAT:,:VKKANGETEXT:,:VKKANGEWIE:,:VKKBESTTEXT:,:VKKBESTWIE:,:VKKLIEFTEXT:,:VKKLIEFWIE:,:VKKRECHTEXT:,:VKKRECHWIE:,:VKKLVORTEXT:,:VKKLVORWIE:,:VKKIVVTTEXT:,:VKKIVVTWIE:,:VKKIVDITEXT:,:VKKIVDIWIE:,:VKKAGT:,:VKKANGEALLG:,:VKKBESTALLG:,:VKKLIEFALLG:,:VKKRECHALLG:,:VKKLVORALLG:,:VKKIVVTALLG:,:VKKIVDIALLG:,:VKKANL1TXT:,:VKKANL2TXT:,:VKKANL3TXT:,:VKKDBLATT:,:VKKTBRIEF:,:VKKARTBILD:,:VKKFORMAT:,:VKKZEUGNIS:,:VKKRES1:,:VKKRES2:,:VKKVKZUABVH:,:VKKVKZUADR:,:VKKKZPRNEU:,:VKKKZFRNEU:,:VKKVAEAKZ:,:VKKMUKRS:,:VKKMULFD:,:VKKMUPOS:,:VKKCPKRS:,:VKKCPLFD:,:VKKCPPOS:,:VKKEDIKZ:,:VKKKOMMNR:,:VKKEDIDAT:,:VKKEDIZEIT:,:VKKABSAUFART:,:VKKARCHKZ:,:VKKARCHDAT:,:VKKARCHBEL:,:VKKOPITEM:,:VKKABSCHR:,:VKKSFEUCHTE:,:VKKAFEUCHTE:,:VKKFEUKZ:,:VKKABRKZ:,:VKKVTYP:,:VKKEXMANDANT:,:VKKWEGBINICH:,:VKKOFFNEU:,:VKKINDEXNA1:,:VKKINDEXBA1:,:VKKINDEXHS1:,:VKKINDEXNA2:,:VKKINDEXBA2:,:VKKINDEXHS2:,:VKKINDEXNA3:,:VKKINDEXBA3:,:VKKINDEXHS3:,:VKKHUELBE:,:VKKRATIFI:,:VKKMU1ANZ:,:VKKMU1GR:,:VKKMU1ME:,:VKKMU1PROMG:,:VKKMU2ANZ:,:VKKMU2GR:,:VKKMU2ME:,:VKKMU2PROMG:,:VKKSPARTE:,:VKKEINSATZG:,:VKKVERWEND:,:VKKERL:,:VKKRD:,:VKKFILLER:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break; 
            } 
            Connect2Proxy(or1);
        }

        public DataSet QueryVKKOPF(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VKKOPF WHERE  ROWNUM<2 ";
                    break;
                case 1:SResult = QVKK01(dwData);break;
                case 2:
                    or1.CommandText = "SELECT VVTLIEFSCH,P.* FROM VKKOPF P JOIN VVTLIEF ON VVTMANDANT=VKKMANDANT AND VVTAUFKRS=VKKAUFKRS AND VVTAUFLFD=VKKAUFLFD AND VVTLIEFSCH=:VKKNEUBEN: WHERE  VKKSA='  ' AND VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1); 
                    break;
                case 3:
                    or1.CommandText = "SELECT DISTINCT VKKMANDANT,VKKAUFSTA,VKKAUFKRS,VKKAUFLFD,VKKNEUDAT,VKKNEUBEN,VKKSACHBE,VKKKDSTA FROM VKKOPF"
                    + " WHERE  VKKSA='  ' AND VKKMANDANT=:VKKMANDANT: AND VKKKUNDNR=:VKKKUNDNR:  "
                    + " ORDER BY VKKAUFKRS||VKKAUFLFD DESC";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1); 
                    break;
                case 4:
                    or1.CommandText = "SELECT * FROM VKKOPF WHERE  VKKSA=:VKKSA: AND VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:"
                        + dwData["VKKSACHBE"].ToString();
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1); 
                    break;
                case 5:
                    or1.CommandText = "SELECT X.*,money2chinese(SUM(VALUE)OVER(PARTITION BY ORDERNO)) AS TOT FROM (select vkkaufkrs||'-'||to_number(vkkauflfd) as orderno,vkkbestnr,trim(k.kdname1)||trim(k.kdname2) as customer, "
                        + " (select trim(substr(sddaten,2,20)) from sddat t where sdsa = '0149' and sdkey like a.vkkmandant||a.vkkhwaehrsl||'%') as currency, "
                        + " (SELECT TRIM(SUBSTR(SDDATEN,52,6)) FROM SDDAT WHERE SDSA = '0192' AND SDKEY LIKE A.VKKMANDANT||A.VKKVG||'%V') AS ACCOUNT, "
                        + " trim(z.zabbez) as payment,b.vkpaufpos,b.vkpkoll,b.vkpart,b.vkpfarbe,B.VKPKDARTNR,B.VKPKDFARBNR,b.vkpmenge1*0.01 as qty, "
                        + " to_number(b.vkppreis)*0.001 as price,b.vkpmeeh,b.vkpliefterm as deldat,v.vaabrtvon*0.01 as width,v.vaagewvon*0.01 as weight,V.VAABEZ, "
                        + " trim(v.vaafiller) as comp,b.vkpmenge1*0.01*to_number(b.vkppreis)*0.001+(c.vkzzuabproz1+c.vkzzuabproz2+c.vkzzuabproz3+c.vkzzuabproz4+c.vkzzuabproz5)*0.0001*b.vkpmenge1*0.01*to_number(b.vkppreis)*0.001+ "
                        + " (c.vkzzuabwert1+c.vkzzuabwert2+c.vkzzuabwert3+c.vkzzuabwert4+c.vkzzuabwert5)*0.01 - "
                        + " (c.vkzrabproz1+c.vkzrabproz2+c.vkzrabproz3+c.vkzrabproz4+c.vkzrabproz5)*0.0001*b.vkpmenge1*0.01*to_number(b.vkppreis)*0.001- "
                        + " (c.vkzverpwert1+c.vkzverpwert2+c.vkzverpwert3+c.vkzverpwert4+c.vkzverpwert5)*0.01 as value, "
                        + " decode(c.vkzzuart1,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0255'  "
                        + " and substr(sdkey,3,3)=c.vkzzuart1)||decode(c.vkzzuabproz1,0,to_char(c.vkzzuabwert1*0.01)||' ',c.vkzzuabproz1*0.01||'% '))||"
                        + " decode(c.vkzzuart2,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0255'  "
                        + " and substr(sdkey,3,3)=c.vkzzuart2)||decode(c.vkzzuabproz2,0,to_char(c.vkzzuabwert2*0.01)||' ',c.vkzzuabproz2*0.01||'% '))||"
                        + " decode(c.vkzzuart3,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0255'  "
                        + " and substr(sdkey,3,3)=c.vkzzuart3)||decode(c.vkzzuabproz3,0,to_char(c.vkzzuabwert3*0.01)||' ',c.vkzzuabproz3*0.01||'% '))||"
                        + " decode(c.vkzzuart4,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0255'  "
                        + " and substr(sdkey,3,3)=c.vkzzuart4)||decode(c.vkzzuabproz4,0,to_char(c.vkzzuabwert4*0.01)||' ',c.vkzzuabproz4*0.01||'% '))||"
                        + " decode(c.vkzzuart5,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0255'  "
                        + " and substr(sdkey,3,3)=c.vkzzuart5)||decode(c.vkzzuabproz5,0,to_char(c.vkzzuabwert5*0.01)||' ',c.vkzzuabproz5*0.01||'% '))||'; '||"
                        + " decode(c.vkzrabart1,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0243'  "
                        + " and substr(sdkey,3,3)=c.vkzrabart1)||decode(c.vkzrabproz1,0,to_char(c.vkzverpwert1*0.01)||' ',c.vkzrabproz1*0.01||'% '))||"
                        + " decode(c.vkzrabart2,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0243'  "
                        + " and substr(sdkey,3,3)=c.vkzrabart2)||decode(c.vkzrabproz2,0,to_char(c.vkzverpwert2*0.01)||' ',c.vkzrabproz2*0.01||'% '))||"
                        + " decode(c.vkzrabart3,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0243'  "
                        + " and substr(sdkey,3,3)=c.vkzrabart3)||decode(c.vkzrabproz3,0,to_char(c.vkzverpwert3*0.01)||' ',c.vkzrabproz3*0.01||'% '))||"
                        + " decode(c.vkzrabart4,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0243'  "
                        + " and substr(sdkey,3,3)=c.vkzrabart4)||decode(c.vkzrabproz4,0,to_char(c.vkzverpwert4*0.01)||' ',c.vkzrabproz4*0.01||'% '))||"
                        + " decode(c.vkzrabart5,'   ','',(select trim(substr(sddaten,52,10)) from sddat where sdsa = '0243'  "
                        + " and substr(sdkey,3,3)=c.vkzrabart5)||decode(c.vkzrabproz5,0,to_char(c.vkzverpwert5*0.01)||' ',c.vkzrabproz5*0.01||'% ')) as sur "
                        + " FROM VKKOPF A,VKPOS B,VKZUAB C,KDSTAMM K,VAART V,ZABED Z "
                        + " WHERE A.VKKMANDANT=:VKKMANDANT: AND a.VKKAUFKRS=:VKKAUFKRS: AND a.VKKAUFLFD=:VKKAUFLFD: "
                        + " AND A.VKKMANDANT = B.VKPMANDANT AND A.VKKSA = B.VKPSA "
                        + " AND A.VKKAUFKRS = B.VKPAUFKRS AND A.VKKAUFLFD = B.VKPAUFLFD AND B.VKPSA = '  '  "
                        + " AND A.VKKMANDANT = K.KDMANDANT AND A.VKKKUNDNR = K.KDKUNDNR "
                        + " AND B.VKPMANDANT = C.VKZMANDANT AND B.VKPAUFKRS = C.VKZAUFKRS AND B.VKPAUFLFD = C.VKZAUFLFD "
                        + " AND B.VKPAUFPOS = C.VKZAUFPOS AND C.VKZSA = 'VK' "
                        + " AND B.VKPMANDANT = V.VAAMANDANT AND B.VKPKOLL = V.VAAKOLL AND B.VKPART = V.VAAART "
                        + " AND A.VKKMANDANT = Z.ZABMANDANT AND a.vkkzahlbed = z.zabnr and zabsprachkz = 'V ') X "
                        + " order by vkpaufpos "
                    ;                    
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);

                    break;
                case 6:
                    or1.CommandText = "SELECT A.VKKAUFART,A.VKKAUFKRS || '-' || to_number(A.VKKAUFLFD) as ORDERNO,vkkbestnr AS CUPO,A.VKKKUNDNR, "
                        + " trim(K.KDNAME1) || trim(K.KDNAME2) as CUSTOMER,trim(K.KDSTRASSE1) || trim(K.KDSTRASSE2) AS CUSTADR, "
                        + " (SELECT TRIM(X.VKALNAME1)||TRIM(X.VKALNAME2) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELNAME,  "
                        + " (SELECT TRIM(X.VKALSTRASSE1)||TRIM(X.VKALSTRASSE2) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELADR,  "
                        + " (SELECT TRIM(X.VKALBZBEZ) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELSTAFF,  "
                        + " (SELECT REPLACE(TRIM(X.VKALORT),':','/') FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELTEL, "
                        + " (SELECT TRIM(T.KDANAME1)||TRIM(T.KDANAME2) FROM VKADR X,KUNDADR T WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000' AND X.VKAMANDANT = T.KDAMANDANT "
                        + " AND X.VKAKUNDNR3 = T.KDAKUNDNR AND X.VKAADRSL3 = T.KDAADRSL) AS INVNAME, "
                        + " (SELECT TRIM(T.KDASTRASSE1)||TRIM(T.KDASTRASSE2) FROM VKADR X,KUNDADR T WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000' AND X.VKAMANDANT = T.KDAMANDANT "
                        + " AND X.VKAKUNDNR3 = T.KDAKUNDNR AND X.VKAADRSL3 = T.KDAADRSL) AS INVADR,  "
                        + " (select trim(substr(sddaten, 2, 20)) from sddat t where sdsa = '0149' and sdkey like a.vkkmandant || a.vkkhwaehrsl || '%') as CURRENCY, "
                        + " (SELECT TRIM(SUBSTR(SDDATEN, 52, 6)) FROM SDDAT WHERE SDSA = '0192' AND SDKEY LIKE A.VKKMANDANT || A.VKKVG || '%V') AS ACCOUNT, "
                        + " trim(z.zabbez) as PAYMENT,A.VKKANSPRECH AS CUSTAFF,D.KDSTEL AS CUTEL,A.VKKSACHBE AS STAFF,TRIM(I.EXCELFILE) AS NAM, "
                        + " TRIM(I.NETDRIVE) AS MOB,TRIM(I.ROOTDRIVE) AS TEL,TRIM(I.UPDATER) AS MAIL,A.VKKNEUDAT  "
                        + " FROM VKKOPF A,KDSTAMM K,ZABED Z,KDANSP D,ICC_HRSTAMM I "
                        + " WHERE A.VKKMANDANT=:VKKMANDANT: AND a.VKKAUFKRS=:VKKAUFKRS: AND a.VKKAUFLFD=:VKKAUFLFD: "
                        + " AND A.VKKMANDANT = K.KDMANDANT AND A.VKKKUNDNR = K.KDKUNDNR "
                        + " AND A.VKKSA = '  ' AND A.VKKMANDANT = Z.ZABMANDANT AND a.vkkzahlbed = z.zabnr "
                        + " and Z.zabsprachkz = 'V ' AND A.VKKMANDANT = D.KDSMANDANT(+) AND A.VKKKUNDNR = D.KDSKUNDNR(+) "
                        + " AND A.VKKANSPRECH = D.KDSANSPNA(+) AND A.VKKMANDANT = I.MANDANT(+) AND trim(A.VKKSACHBE) = trim(I.USERID(+)) ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1); 
                    break;
                case -2:
                    or1.CommandText = "SELECT DISTINCT VKKBESTNR,VKKBESTNR AS BESTNR FROM VKKOPF M ";
                    SResult = Connect2Proxy(or1); 
                    break; 
            }

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVKK01(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VKKOPF WHERE ( VKKSA='  ' OR VKKSA='IN')  AND VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:"
            + dwData["VKKSACHBE"].ToString();
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVKKXX(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM VKKOPF WHERE VKKMANDANT=:VKKMANDANT:  ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVKK99(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand(); 
            or1.CommandText = "SELECT * FROM VKKOPF WHERE VKKMANDANT=:VKKMANDANT:  ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);  
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }

        public void UpdateVKKOPF(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            if (dwData != null)
            {
                dwData["VKKAENDDAT"] = date;
                dwData["VKKAENDBEN"] = app.User;
            }
            if (option == 0)
            {
                switch (app.company)
                {
                    case "YGR":
                    case "SXN":
                    case "TST":
                    case "UBT":
                        option = 2;
                        break;
                    case "JLT":
                        option = 3;
                        break;
                    default:
                        option = 1;
                        break;
                }
            }
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1: UVKK01(dwData); break;
                case 2: UVKK02(dwData); break;
                case 3: UVKK03(dwData); break;
                case 4: UVKK04(dwData); break;
                case 5: UVKK05(dwData); break;
                case 6: UVKK06(dwData); break;
                case 7: UVKK07(dwData); break;
                case 8: UVKK08(dwData); break;
                case 20: UVKK20(dwData); break;  
            }
         }
        public void UVKK01(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            #region====Command====

            or1.CommandText = "UPDATE VKKOPF SET VKKLIEFALLG=:VKKLIEFALLG:,VKKRECHALLG=:VKKRECHALLG:,VKKLVORALLG=:VKKLVORALLG:,"
                + "VKKIVVTALLG=:VKKIVVTALLG:,VKKIVDIALLG=:VKKIVDIALLG:,VKKANL1TXT=:VKKANL1TXT:,VKKANL2TXT=:VKKANL2TXT:,VKKANL3TXT=:VKKANL3TXT:,"
                + "VKKDBLATT=:VKKDBLATT:,VKKTBRIEF=:VKKTBRIEF:,VKKARTBILD=:VKKARTBILD:,VKKFORMAT=:VKKFORMAT:,VKKZEUGNIS=:VKKZEUGNIS:,VKKRES1=:VKKRES1:,"
                + "VKKRES2=:VKKRES2:,VKKVKZUABVH=:VKKVKZUABVH:,VKKVKZUADR=:VKKVKZUADR:,VKKKZPRNEU=:VKKKZPRNEU:,VKKKZFRNEU=:VKKKZFRNEU:,VKKVAEAKZ=:VKKVAEAKZ:,"
                + "VKKMUKRS=:VKKMUKRS:,VKKMULFD=:VKKMULFD:,VKKMUPOS=:VKKMUPOS:,VKKCPKRS=:VKKCPKRS:,VKKCPLFD=:VKKCPLFD:,VKKCPPOS=:VKKCPPOS:,"
                + "VKKEDIKZ=:VKKEDIKZ:,VKKKOMMNR=:VKKKOMMNR:,VKKEDIDAT=:VKKEDIDAT:,VKKEDIZEIT=:VKKEDIZEIT:,VKKABSAUFART=:VKKABSAUFART:,VKKARCHKZ=:VKKARCHKZ:,"
                + "VKKARCHDAT=:VKKARCHDAT:,VKKARCHBEL=:VKKARCHBEL:,VKKOPITEM=:VKKOPITEM:,VKKABSCHR=:VKKABSCHR:,VKKSFEUCHTE=:VKKSFEUCHTE:,VKKAFEUCHTE=:VKKAFEUCHTE:,VKKFEUKZ=:VKKFEUKZ:,"
                + "VKKABRKZ=:VKKABRKZ:,VKKVTYP=:VKKVTYP:,VKKEXMANDANT=:VKKEXMANDANT:,VKKWEGBINICH=:VKKWEGBINICH:,VKKOFFNEU=:VKKOFFNEU:,VKKINDEXNA1=:VKKINDEXNA1:,VKKINDEXBA1=:VKKINDEXBA1:,"
                + "VKKINDEXHS1=:VKKINDEXHS1:,VKKINDEXNA2=:VKKINDEXNA2:,VKKINDEXBA2=:VKKINDEXBA2:,VKKINDEXHS2=:VKKINDEXHS2:,VKKINDEXNA3=:VKKINDEXNA3:,VKKINDEXBA3=:VKKINDEXBA3:,"
                + "VKKINDEXHS3=:VKKINDEXHS3:,VKKHUELBE=:VKKHUELBE:,VKKRATIFI=:VKKRATIFI:,VKKMU1ANZ=:VKKMU1ANZ:,VKKMU1GR=:VKKMU1GR:,VKKMU1ME=:VKKMU1ME:,VKKMU1PROMG=:VKKMU1PROMG:,"
                + "VKKMU2ANZ=:VKKMU2ANZ:,VKKMU2GR=:VKKMU2GR:,VKKMU2ME=:VKKMU2ME:,VKKMU2PROMG=:VKKMU2PROMG:,VKKFILLER=:VKKFILLER:,VKKPRGRPV=:VKKPRGRPV:,VKKPRGRPZ=:VKKPRGRPZ:,"
                + "VKKPRGRPSTD=:VKKPRGRPSTD:,VKKPROJNR=:VKKPROJNR:,VKKVKART=:VKKVKART:,VKKKUNDNRST=:VKKKUNDNRST:,VKKABNGRPST=:VKKABNGRPST:,VKKGLOBAL=:VKKGLOBAL:,"
                + "VKKKOMENGE=:VKKKOMENGE:,VKKEINGET=:VKKEINGET:,VKKOFFEN=:VKKOFFEN:,VKKEINGETOV=:VKKEINGETOV:,VKKEINGETPO=:VKKEINGETPO:,VKKCORQTY=:VKKCORQTY:,VKKLIMGWO=:VKKLIMGWO:,VKKMEEH=:VKKMEEH:,"
                + "VKKMEEHGRP=:VKKMEEHGRP:,VKKMEEHFKT=:VKKMEEHFKT:,VKKKOMENGET1=:VKKKOMENGET1:,VKKKOMENGET2=:VKKKOMENGET2:,VKKKOMENGET3=:VKKKOMENGET3:,VKKKOMENGET4=:VKKKOMENGET4:,VKKEINTT1=:VKKEINTT1:,"
                + "VKKEINTT2=:VKKEINTT2:,VKKEINTT3=:VKKEINTT3:,VKKEINTT4=:VKKEINTT4:,VKKOFFENT1=:VKKOFFENT1:,VKKOFFENT2=:VKKOFFENT2:,VKKOFFENT3=:VKKOFFENT3:,VKKOFFENT4=:VKKOFFENT4:,"
                + "VKKEINTTOV1=:VKKEINTTOV1:,VKKEINTTOV2=:VKKEINTTOV2:,VKKEINTTOV3=:VKKEINTTOV3:,VKKEINTTOV4=:VKKEINTTOV4:,VKKEINTTPO1=:VKKEINTTPO1:,VKKEINTTPO2=:VKKEINTTPO2:,"
                + "VKKEINTTPO3=:VKKEINTTPO3:,VKKEINTTPO4=:VKKEINTTPO4:,VKKCORQTYT1=:VKKCORQTYT1:,VKKCORQTYT2=:VKKCORQTYT2:,VKKCORQTYT3=:VKKCORQTYT3:,VKKCORQTYT4=:VKKCORQTYT4:,VKKLIMGWOT1=:VKKLIMGWOT1:,"
                + "VKKLIMGWOT2=:VKKLIMGWOT2:,VKKLIMGWOT3=:VKKLIMGWOT3:,VKKLIMGWOT4=:VKKLIMGWOT4:,VKKRSTBEZ=:VKKRSTBEZ:,VKKOPTION=:VKKOPTION:,VKKOPTANBIS=:VKKOPTANBIS:,"
                + "VKKOPTANAM=:VKKOPTANAM:,VKKDECKPROZ=:VKKDECKPROZ:,VKKWDECKDAT=:VKKWDECKDAT:,VKKUEBEINT=:VKKUEBEINT:,VKKMINBEST=:VKKMINBEST:,VKKMAXBEST=:VKKMAXBEST:,VKKSCHRAST=:VKKSCHRAST:,VKKGESMENGE1=:VKKGESMENGE1:,"
                + "VKKGESMENGE2=:VKKGESMENGE2:,VKKGESMENGE3=:VKKGESMENGE3:,VKKGESMENGE4=:VKKGESMENGE4:,VKKGESWERT=:VKKGESWERT:,VKKCOVPRC=:VKKCOVPRC:,VKKAKKREDNR=:VKKAKKREDNR:,VKKGESSTA=:VKKGESSTA:,VKKKDSTA=:VKKKDSTA:,"
                + "VKKAUFSTA=:VKKAUFSTA:,VKKPOSSTA=:VKKPOSSTA:,VKKSTA4=:VKKSTA4:,VKKKURS=:VKKKURS:,VKKBETRAG=:VKKBETRAG:,VKKVKURS=:VKKVKURS:,VKKVBETRAG=:VKKVBETRAG:,VKKSCHWPLU=:VKKSCHWPLU:,"
                + "VKKSCHWMIN=:VKKSCHWMIN:,VKKHWAEHRSL=:VKKHWAEHRSL:,VKKHEUROKURS=:VKKHEUROKURS:,VKKHEUROKURSVK=:VKKHEUROKURSVK:,VKKFEUROKURS=:VKKFEUROKURS:,"
                + "VKKFEUROKURSVK=:VKKFEUROKURSVK:,VKKALTWAEHR=:VKKALTWAEHR:,VKKALTWAEHRF=:VKKALTWAEHRF:,VKKVALUTA=:VKKVALUTA:,VKKVALDAT=:VKKVALDAT:,VKKWAEHRSL=:VKKWAEHRSL:,"
                + "VKKZAHLBED=:VKKZAHLBED:,VKKEKON=:VKKEKON:,VKKKDVKL=:VKKKDVKL:,VKKLIEFBED=:VKKLIEFBED:,VKKLANDU=:VKKLANDU:,VKKPLZU=:VKKPLZU:,VKKORTU=:VKKORTU:,VKKBZU=:VKKBZU:,"
                + "VKKBZBEZU=:VKKBZBEZU:,VKKCOUNTYU=:VKKCOUNTYU:,VKKCITYU=:VKKCITYU:,VKKLIEFKOMP=:VKKLIEFKOMP:,VKKVERSART=:VKKVERSART:,VKKSPED=:VKKSPED:,VKKZUSATZ=:VKKZUSATZ:,VKKDRBEST=:VKKDRBEST:,VKKBSTDAT=:VKKBSTDAT:,"
                + "VKKANGETEXT=:VKKANGETEXT:,VKKANGEWIE=:VKKANGEWIE:,VKKBESTTEXT=:VKKBESTTEXT:,VKKBESTWIE=:VKKBESTWIE:,VKKLIEFTEXT=:VKKLIEFTEXT:,VKKLIEFWIE=:VKKLIEFWIE:,VKKRECHTEXT=:VKKRECHTEXT:,"
                + "VKKRECHWIE=:VKKRECHWIE:,VKKLVORTEXT=:VKKLVORTEXT:,VKKLVORWIE=:VKKLVORWIE:,VKKIVVTTEXT=:VKKIVVTTEXT:,VKKIVVTWIE=:VKKIVVTWIE:,VKKIVDITEXT=:VKKIVDITEXT:,VKKIVDIWIE=:VKKIVDIWIE:,VKKAGT=:VKKAGT:,"
                + "VKKANGEALLG=:VKKANGEALLG:,VKKBESTALLG=:VKKBESTALLG:,VKKMANDANT=:VKKMANDANT:,VKKSA=:VKKSA:,VKKAUFKRS=:VKKAUFKRS:,VKKAUFLFD=:VKKAUFLFD:,VKKAENDST=:VKKAENDST:,"
                + "VKKAENDZL=:VKKAENDZL:,VKKAENDBEN=:VKKAENDBEN:,VKKAENDDAT=:VKKAENDDAT:,VKKNEUBEN=:VKKNEUBEN:,VKKNEUDAT=:VKKNEUDAT:,VKKAESTAT=:VKKAESTAT:,"
                + "VKKAUFART=:VKKAUFART:,VKKKUNDNR=:VKKKUNDNR:,VKKVB=:VKKVB:,VKKVG=:VKKVG:,VKKADRSL=:VKKADRSL:,VKKVERBNR=:VKKVERBNR:,VKKZENTR=:VKKZENTR:,VKKZENTRR=:VKKZENTRR:,VKKKREDKDNR=:VKKKREDKDNR:,VKKKDARTBEZ=:VKKKDARTBEZ:,VKKORDER=:VKKORDER:,"
                + "VKKANSPRECH=:VKKANSPRECH:,VKKANSPZUS=:VKKANSPZUS:,VKKBESTNR=:VKKBESTNR:,VKKBESTDAT=:VKKBESTDAT:,VKKGLTVON=:VKKGLTVON:,VKKGLTBIS=:VKKGLTBIS:,"
                + "VKKETAB=:VKKETAB:,VKKBESTSB=:VKKBESTSB:,VKKAEDAT=:VKKAEDAT:,VKKSACHBE=:VKKSACHBE:,VKKPRGRP=:VKKPRGRP:"
                + " WHERE   VKKSA<>'AJ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
            #endregion
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKMANDANT=:VKKMANDANT:,VKKSA=:VKKSA:,VKKAUFKRS=:VKKAUFKRS:,VKKAUFLFD=:VKKAUFLFD:,VKKAENDST=:VKKAENDST:,VKKAENDZL=:VKKAENDZL:,VKKAENDBEN=:VKKAENDBEN:,VKKAENDDAT=:VKKAENDDAT:,VKKNEUBEN=:VKKNEUBEN:,VKKNEUDAT=:VKKNEUDAT:,VKKAESTAT=:VKKAESTAT:,VKKAUFART=:VKKAUFART:,VKKKUNDNR=:VKKKUNDNR:,VKKVB=:VKKVB:,VKKVG=:VKKVG:,VKKADRSL=:VKKADRSL:,VKKVERBNR=:VKKVERBNR:,VKKZENTR=:VKKZENTR:,VKKZENTRR=:VKKZENTRR:,VKKKREDKDNR=:VKKKREDKDNR:,VKKKDARTBEZ=:VKKKDARTBEZ:,VKKORDER=:VKKORDER:,VKKANSPRECH=:VKKANSPRECH:,VKKANSPZUS=:VKKANSPZUS:,VKKBESTNR=:VKKBESTNR:,VKKBESTDAT=:VKKBESTDAT:,VKKGLTVON=:VKKGLTVON:,VKKGLTBIS=:VKKGLTBIS:,VKKETAB=:VKKETAB:,VKKBESTSB=:VKKBESTSB:,VKKAEDAT=:VKKAEDAT:,VKKSACHBE=:VKKSACHBE:,VKKPRGRP=:VKKPRGRP:,VKKPRGRPV=:VKKPRGRPV:,VKKPRGRPZ=:VKKPRGRPZ:,VKKPRGRPSTD=:VKKPRGRPSTD:,VKKPROJNR=:VKKPROJNR:,VKKVKART=:VKKVKART:,VKKKUNDNRST=:VKKKUNDNRST:,VKKABNGRPST=:VKKABNGRPST:,VKKGLOBAL=:VKKGLOBAL:,VKKKOMENGE=:VKKKOMENGE:,VKKEINGET=:VKKEINGET:,VKKOFFEN=:VKKOFFEN:,VKKEINGETOV=:VKKEINGETOV:,VKKEINGETPO=:VKKEINGETPO:,VKKCORQTY=:VKKCORQTY:,VKKLIMGWO=:VKKLIMGWO:,VKKMEEH=:VKKMEEH:,VKKMEEHGRP=:VKKMEEHGRP:,VKKMEEHFKT=:VKKMEEHFKT:,VKKKOMENGET1=:VKKKOMENGET1:,VKKKOMENGET2=:VKKKOMENGET2:,VKKKOMENGET3=:VKKKOMENGET3:,VKKKOMENGET4=:VKKKOMENGET4:,VKKEINTT1=:VKKEINTT1:,VKKEINTT2=:VKKEINTT2:,VKKEINTT3=:VKKEINTT3:,VKKEINTT4=:VKKEINTT4:,VKKOFFENT1=:VKKOFFENT1:,VKKOFFENT2=:VKKOFFENT2:,VKKOFFENT3=:VKKOFFENT3:,VKKOFFENT4=:VKKOFFENT4:,VKKEINTTOV1=:VKKEINTTOV1:,VKKEINTTOV2=:VKKEINTTOV2:,VKKEINTTOV3=:VKKEINTTOV3:,VKKEINTTOV4=:VKKEINTTOV4:,VKKEINTTPO1=:VKKEINTTPO1:,VKKEINTTPO2=:VKKEINTTPO2:,VKKEINTTPO3=:VKKEINTTPO3:,VKKEINTTPO4=:VKKEINTTPO4:,VKKCORQTYT1=:VKKCORQTYT1:,VKKCORQTYT2=:VKKCORQTYT2:,VKKCORQTYT3=:VKKCORQTYT3:,VKKCORQTYT4=:VKKCORQTYT4:,VKKLIMGWOT1=:VKKLIMGWOT1:,VKKLIMGWOT2=:VKKLIMGWOT2:,VKKLIMGWOT3=:VKKLIMGWOT3:,VKKLIMGWOT4=:VKKLIMGWOT4:,VKKRSTBEZ=:VKKRSTBEZ:,VKKOPTION=:VKKOPTION:,VKKOPTANBIS=:VKKOPTANBIS:,VKKOPTANAM=:VKKOPTANAM:,VKKDECKPROZ=:VKKDECKPROZ:,VKKWDECKDAT=:VKKWDECKDAT:,VKKUEBEINT=:VKKUEBEINT:,VKKMINBEST=:VKKMINBEST:,VKKMAXBEST=:VKKMAXBEST:,VKKSCHRAST=:VKKSCHRAST:,VKKGESMENGE1=:VKKGESMENGE1:,VKKGESMENGE2=:VKKGESMENGE2:,VKKGESMENGE3=:VKKGESMENGE3:,VKKGESMENGE4=:VKKGESMENGE4:,VKKGESWERT=:VKKGESWERT:,VKKCOVPRC=:VKKCOVPRC:,VKKAKKREDNR=:VKKAKKREDNR:,VKKGESSTA=:VKKGESSTA:,VKKKDSTA=:VKKKDSTA:,VKKAUFSTA=:VKKAUFSTA:,VKKPOSSTA=:VKKPOSSTA:,VKKSTA4=:VKKSTA4:,VKKKURS=:VKKKURS:,VKKBETRAG=:VKKBETRAG:,VKKVKURS=:VKKVKURS:,VKKVBETRAG=:VKKVBETRAG:,VKKSCHWPLU=:VKKSCHWPLU:,VKKSCHWMIN=:VKKSCHWMIN:,VKKHWAEHRSL=:VKKHWAEHRSL:,VKKHEUROKURS=:VKKHEUROKURS:,VKKHEUROKURSVK=:VKKHEUROKURSVK:,VKKFEUROKURS=:VKKFEUROKURS:,VKKFEUROKURSVK=:VKKFEUROKURSVK:,VKKALTWAEHR=:VKKALTWAEHR:,VKKALTWAEHRF=:VKKALTWAEHRF:,VKKVALUTA=:VKKVALUTA:,VKKVALDAT=:VKKVALDAT:,VKKWAEHRSL=:VKKWAEHRSL:,VKKZAHLBED=:VKKZAHLBED:,VKKEKON=:VKKEKON:,VKKKDVKL=:VKKKDVKL:,VKKLIEFBED=:VKKLIEFBED:,VKKLANDU=:VKKLANDU:,VKKPLZU=:VKKPLZU:,VKKORTU=:VKKORTU:,VKKBZU=:VKKBZU:,VKKBZBEZU=:VKKBZBEZU:,VKKCOUNTYU=:VKKCOUNTYU:,VKKCITYU=:VKKCITYU:,VKKLIEFKOMP=:VKKLIEFKOMP:,VKKVERSART=:VKKVERSART:,VKKSPED=:VKKSPED:,VKKZUSATZ=:VKKZUSATZ:,VKKDRBEST=:VKKDRBEST:,VKKBSTDAT=:VKKBSTDAT:,VKKANGETEXT=:VKKANGETEXT:,VKKANGEWIE=:VKKANGEWIE:,VKKBESTTEXT=:VKKBESTTEXT:,VKKBESTWIE=:VKKBESTWIE:,VKKLIEFTEXT=:VKKLIEFTEXT:,VKKLIEFWIE=:VKKLIEFWIE:,VKKRECHTEXT=:VKKRECHTEXT:,VKKRECHWIE=:VKKRECHWIE:,VKKLVORTEXT=:VKKLVORTEXT:,VKKLVORWIE=:VKKLVORWIE:,VKKIVVTTEXT=:VKKIVVTTEXT:,VKKIVVTWIE=:VKKIVVTWIE:,VKKIVDITEXT=:VKKIVDITEXT:,VKKIVDIWIE=:VKKIVDIWIE:,VKKAGT=:VKKAGT:,VKKANGEALLG=:VKKANGEALLG:,VKKBESTALLG=:VKKBESTALLG:,VKKLIEFALLG=:VKKLIEFALLG:,VKKRECHALLG=:VKKRECHALLG:,VKKLVORALLG=:VKKLVORALLG:,VKKIVVTALLG=:VKKIVVTALLG:,VKKIVDIALLG=:VKKIVDIALLG:,VKKANL1TXT=:VKKANL1TXT:,VKKANL2TXT=:VKKANL2TXT:,VKKANL3TXT=:VKKANL3TXT:,VKKDBLATT=:VKKDBLATT:,VKKTBRIEF=:VKKTBRIEF:,VKKARTBILD=:VKKARTBILD:,VKKFORMAT=:VKKFORMAT:,VKKZEUGNIS=:VKKZEUGNIS:,VKKRES1=:VKKRES1:,VKKRES2=:VKKRES2:,VKKVKZUABVH=:VKKVKZUABVH:,VKKVKZUADR=:VKKVKZUADR:,VKKKZPRNEU=:VKKKZPRNEU:,VKKKZFRNEU=:VKKKZFRNEU:,VKKVAEAKZ=:VKKVAEAKZ:,VKKMUKRS=:VKKMUKRS:,VKKMULFD=:VKKMULFD:,VKKMUPOS=:VKKMUPOS:,VKKCPKRS=:VKKCPKRS:,VKKCPLFD=:VKKCPLFD:,VKKCPPOS=:VKKCPPOS:,VKKEDIKZ=:VKKEDIKZ:,VKKKOMMNR=:VKKKOMMNR:,VKKEDIDAT=:VKKEDIDAT:,VKKEDIZEIT=:VKKEDIZEIT:,VKKABSAUFART=:VKKABSAUFART:,VKKARCHKZ=:VKKARCHKZ:,VKKARCHDAT=:VKKARCHDAT:,VKKARCHBEL=:VKKARCHBEL:,VKKOPITEM=:VKKOPITEM:,VKKABSCHR=:VKKABSCHR:,VKKSFEUCHTE=:VKKSFEUCHTE:,VKKAFEUCHTE=:VKKAFEUCHTE:,VKKFEUKZ=:VKKFEUKZ:,VKKABRKZ=:VKKABRKZ:,VKKVTYP=:VKKVTYP:,VKKEXMANDANT=:VKKEXMANDANT:,VKKWEGBINICH=:VKKWEGBINICH:,VKKOFFNEU=:VKKOFFNEU:,VKKINDEXNA1=:VKKINDEXNA1:,VKKINDEXBA1=:VKKINDEXBA1:,VKKINDEXHS1=:VKKINDEXHS1:,VKKINDEXNA2=:VKKINDEXNA2:,VKKINDEXBA2=:VKKINDEXBA2:,VKKINDEXHS2=:VKKINDEXHS2:,VKKINDEXNA3=:VKKINDEXNA3:,VKKINDEXBA3=:VKKINDEXBA3:,VKKINDEXHS3=:VKKINDEXHS3:,VKKHUELBE=:VKKHUELBE:,VKKRATIFI=:VKKRATIFI:,VKKMU1ANZ=:VKKMU1ANZ:,VKKMU1GR=:VKKMU1GR:,VKKMU1ME=:VKKMU1ME:,VKKMU1PROMG=:VKKMU1PROMG:,VKKMU2ANZ=:VKKMU2ANZ:,VKKMU2GR=:VKKMU2GR:,VKKMU2ME=:VKKMU2ME:,VKKMU2PROMG=:VKKMU2PROMG:,VKKSPARTE=:VKKSPARTE:,VKKEINSATZG=:VKKEINSATZG:,VKKVERWEND=:VKKVERWEND:,VKKERL=:VKKERL:,VKKRD=:VKKRD:,VKKFILLER=:VKKFILLER:"
                      + " WHERE VKKSA<>'AJ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK03(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKMANDANT=:VKKMANDANT:,VKKSA=:VKKSA:,VKKAUFKRS=:VKKAUFKRS:,VKKAUFLFD=:VKKAUFLFD:,VKKAENDST=:VKKAENDST:,VKKAENDZL=:VKKAENDZL:,VKKAENDBEN=:VKKAENDBEN:,VKKAENDDAT=:VKKAENDDAT:,VKKNEUBEN=:VKKNEUBEN:,VKKNEUDAT=:VKKNEUDAT:,VKKAESTAT=:VKKAESTAT:,VKKAUFART=:VKKAUFART:,VKKKUNDNR=:VKKKUNDNR:,VKKVB=:VKKVB:,VKKVG=:VKKVG:,VKKADRSL=:VKKADRSL:,VKKVERBNR=:VKKVERBNR:,VKKZENTR=:VKKZENTR:,VKKZENTRR=:VKKZENTRR:,VKKKREDKDNR=:VKKKREDKDNR:,VKKKDARTBEZ=:VKKKDARTBEZ:,VKKORDER=:VKKORDER:,VKKANSPRECH=:VKKANSPRECH:,VKKANSPZUS=:VKKANSPZUS:,VKKBESTNR=:VKKBESTNR:,VKKBESTDAT=:VKKBESTDAT:,VKKGLTVON=:VKKGLTVON:,VKKGLTBIS=:VKKGLTBIS:,VKKETAB=:VKKETAB:,VKKBESTSB=:VKKBESTSB:,VKKAEDAT=:VKKAEDAT:,VKKSACHBE=:VKKSACHBE:,VKKPRGRP=:VKKPRGRP:,VKKPRGRPV=:VKKPRGRPV:,VKKPRGRPZ=:VKKPRGRPZ:,VKKPRGRPSTD=:VKKPRGRPSTD:,VKKPROJNR=:VKKPROJNR:,VKKVKART=:VKKVKART:,VKKKUNDNRST=:VKKKUNDNRST:,VKKABNGRPST=:VKKABNGRPST:,VKKGLOBAL=:VKKGLOBAL:,VKKKOMENGE=:VKKKOMENGE:,VKKEINGET=:VKKEINGET:,VKKOFFEN=:VKKOFFEN:,VKKEINGETOV=:VKKEINGETOV:,VKKEINGETPO=:VKKEINGETPO:,VKKCORQTY=:VKKCORQTY:,VKKLIMGWO=:VKKLIMGWO:,VKKMEEH=:VKKMEEH:,VKKMEEHGRP=:VKKMEEHGRP:,VKKMEEHFKT=:VKKMEEHFKT:,VKKKOMENGET1=:VKKKOMENGET1:,VKKKOMENGET2=:VKKKOMENGET2:,VKKKOMENGET3=:VKKKOMENGET3:,VKKKOMENGET4=:VKKKOMENGET4:,VKKEINTT1=:VKKEINTT1:,VKKEINTT2=:VKKEINTT2:,VKKEINTT3=:VKKEINTT3:,VKKEINTT4=:VKKEINTT4:,VKKOFFENT1=:VKKOFFENT1:,VKKOFFENT2=:VKKOFFENT2:,VKKOFFENT3=:VKKOFFENT3:,VKKOFFENT4=:VKKOFFENT4:,VKKEINTTOV1=:VKKEINTTOV1:,VKKEINTTOV2=:VKKEINTTOV2:,VKKEINTTOV3=:VKKEINTTOV3:,VKKEINTTOV4=:VKKEINTTOV4:,VKKEINTTPO1=:VKKEINTTPO1:,VKKEINTTPO2=:VKKEINTTPO2:,VKKEINTTPO3=:VKKEINTTPO3:,VKKEINTTPO4=:VKKEINTTPO4:,VKKCORQTYT1=:VKKCORQTYT1:,VKKCORQTYT2=:VKKCORQTYT2:,VKKCORQTYT3=:VKKCORQTYT3:,VKKCORQTYT4=:VKKCORQTYT4:,VKKLIMGWOT1=:VKKLIMGWOT1:,VKKLIMGWOT2=:VKKLIMGWOT2:,VKKLIMGWOT3=:VKKLIMGWOT3:,VKKLIMGWOT4=:VKKLIMGWOT4:,VKKRSTBEZ=:VKKRSTBEZ:,VKKOPTION=:VKKOPTION:,VKKOPTANBIS=:VKKOPTANBIS:,VKKOPTANAM=:VKKOPTANAM:,VKKDECKPROZ=:VKKDECKPROZ:,VKKWDECKDAT=:VKKWDECKDAT:,VKKUEBEINT=:VKKUEBEINT:,VKKMINBEST=:VKKMINBEST:,VKKMAXBEST=:VKKMAXBEST:,VKKSCHRAST=:VKKSCHRAST:,VKKGESMENGE1=:VKKGESMENGE1:,VKKGESMENGE2=:VKKGESMENGE2:,VKKGESMENGE3=:VKKGESMENGE3:,VKKGESMENGE4=:VKKGESMENGE4:,VKKGESWERT=:VKKGESWERT:,VKKCOVPRC=:VKKCOVPRC:,VKKAKKREDNR=:VKKAKKREDNR:,VKKGESSTA=:VKKGESSTA:,VKKKDSTA=:VKKKDSTA:,VKKAUFSTA=:VKKAUFSTA:,VKKPOSSTA=:VKKPOSSTA:,VKKSTA4=:VKKSTA4:,VKKKURS=:VKKKURS:,VKKBETRAG=:VKKBETRAG:,VKKVKURS=:VKKVKURS:,VKKVBETRAG=:VKKVBETRAG:,VKKSCHWPLU=:VKKSCHWPLU:,VKKSCHWMIN=:VKKSCHWMIN:,VKKHWAEHRSL=:VKKHWAEHRSL:,VKKHEUROKURS=:VKKHEUROKURS:,VKKHEUROKURSVK=:VKKHEUROKURSVK:,VKKFEUROKURS=:VKKFEUROKURS:,VKKFEUROKURSVK=:VKKFEUROKURSVK:,VKKALTWAEHR=:VKKALTWAEHR:,VKKALTWAEHRF=:VKKALTWAEHRF:,VKKVALUTA=:VKKVALUTA:,VKKVALDAT=:VKKVALDAT:,VKKWAEHRSL=:VKKWAEHRSL:,VKKZAHLBED=:VKKZAHLBED:,VKKEKON=:VKKEKON:,VKKKDVKL=:VKKKDVKL:,VKKLIEFBED=:VKKLIEFBED:,VKKLANDU=:VKKLANDU:,VKKPLZU=:VKKPLZU:,VKKORTU=:VKKORTU:,VKKBZU=:VKKBZU:,VKKBZBEZU=:VKKBZBEZU:,VKKCOUNTYU=:VKKCOUNTYU:,VKKCITYU=:VKKCITYU:,VKKLIEFKOMP=:VKKLIEFKOMP:,VKKVERSART=:VKKVERSART:,VKKSPED=:VKKSPED:,VKKZUSATZ=:VKKZUSATZ:,VKKDRBEST=:VKKDRBEST:,VKKBSTDAT=:VKKBSTDAT:,VKKANGETEXT=:VKKANGETEXT:,VKKANGEWIE=:VKKANGEWIE:,VKKBESTTEXT=:VKKBESTTEXT:,VKKBESTWIE=:VKKBESTWIE:,VKKLIEFTEXT=:VKKLIEFTEXT:,VKKLIEFWIE=:VKKLIEFWIE:,VKKRECHTEXT=:VKKRECHTEXT:,VKKRECHWIE=:VKKRECHWIE:,VKKLVORTEXT=:VKKLVORTEXT:,VKKLVORWIE=:VKKLVORWIE:,VKKIVVTTEXT=:VKKIVVTTEXT:,VKKIVVTWIE=:VKKIVVTWIE:,VKKIVDITEXT=:VKKIVDITEXT:,VKKIVDIWIE=:VKKIVDIWIE:,VKKAGT=:VKKAGT:,VKKANGEALLG=:VKKANGEALLG:,VKKBESTALLG=:VKKBESTALLG:,VKKLIEFALLG=:VKKLIEFALLG:,VKKRECHALLG=:VKKRECHALLG:,VKKLVORALLG=:VKKLVORALLG:,VKKIVVTALLG=:VKKIVVTALLG:,VKKIVDIALLG=:VKKIVDIALLG:,VKKANL1TXT=:VKKANL1TXT:,VKKANL2TXT=:VKKANL2TXT:,VKKANL3TXT=:VKKANL3TXT:,VKKDBLATT=:VKKDBLATT:,VKKTBRIEF=:VKKTBRIEF:,VKKARTBILD=:VKKARTBILD:,VKKFORMAT=:VKKFORMAT:,VKKZEUGNIS=:VKKZEUGNIS:,VKKRES1=:VKKRES1:,VKKRES2=:VKKRES2:,VKKVKZUABVH=:VKKVKZUABVH:,VKKVKZUADR=:VKKVKZUADR:,VKKKZPRNEU=:VKKKZPRNEU:,VKKKZFRNEU=:VKKKZFRNEU:,VKKVAEAKZ=:VKKVAEAKZ:,VKKMUKRS=:VKKMUKRS:,VKKMULFD=:VKKMULFD:,VKKMUPOS=:VKKMUPOS:,VKKCPKRS=:VKKCPKRS:,VKKCPLFD=:VKKCPLFD:,VKKCPPOS=:VKKCPPOS:,VKKEDIKZ=:VKKEDIKZ:,VKKKOMMNR=:VKKKOMMNR:,VKKEDIDAT=:VKKEDIDAT:,VKKEDIZEIT=:VKKEDIZEIT:,VKKABSAUFART=:VKKABSAUFART:,VKKARCHKZ=:VKKARCHKZ:,VKKARCHDAT=:VKKARCHDAT:,VKKARCHBEL=:VKKARCHBEL:,VKKOPITEM=:VKKOPITEM:,VKKABSCHR=:VKKABSCHR:,VKKSFEUCHTE=:VKKSFEUCHTE:,VKKAFEUCHTE=:VKKAFEUCHTE:,VKKFEUKZ=:VKKFEUKZ:,VKKABRKZ=:VKKABRKZ:,VKKVTYP=:VKKVTYP:,VKKEXMANDANT=:VKKEXMANDANT:,VKKWEGBINICH=:VKKWEGBINICH:,VKKOFFNEU=:VKKOFFNEU:,VKKINDEXNA1=:VKKINDEXNA1:,VKKINDEXBA1=:VKKINDEXBA1:,VKKINDEXHS1=:VKKINDEXHS1:,VKKINDEXNA2=:VKKINDEXNA2:,VKKINDEXBA2=:VKKINDEXBA2:,VKKINDEXHS2=:VKKINDEXHS2:,VKKINDEXNA3=:VKKINDEXNA3:,VKKINDEXBA3=:VKKINDEXBA3:,VKKINDEXHS3=:VKKINDEXHS3:,VKKHUELBE=:VKKHUELBE:,VKKRATIFI=:VKKRATIFI:,VKKMU1ANZ=:VKKMU1ANZ:,VKKMU1GR=:VKKMU1GR:,VKKMU1ME=:VKKMU1ME:,VKKMU1PROMG=:VKKMU1PROMG:,VKKMU2ANZ=:VKKMU2ANZ:,VKKMU2GR=:VKKMU2GR:,VKKMU2ME=:VKKMU2ME:,VKKMU2PROMG=:VKKMU2PROMG:,VKKSPARTE=:VKKSPARTE:,VKKEINSATZG=:VKKEINSATZG:,VKKVERWEND=:VKKVERWEND:,VKKERL=:VKKERL:,VKKRD=:VKKRD:,VKKFILLER=:VKKFILLER:"
                      + " WHERE VKKSA<>'AJ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK04(DataRow dwData)
        {
            dwData = TBMain.NewRow();
            SetUpNewRow(ref dwData);
            dwData["VKKMANDANT"] = "99";
            dwData["VKKSA"] = "AJ";
            dwData["VKKAUFKRS"] = "AJ";
            InsertVKKOPF(dwData);
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKAENDZL=VKKAENDZL+1 WHERE VKKMANDANT='99'";
            Connect2Proxy(or1);
        }
        public void UVKK05(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET (VKKGESMENGE1,VKKGESMENGE2,VKKGESMENGE3,VKKGESMENGE4,VKKGESWERT) "
                    + " =(SELECT SUM(VKPMENGE1T1)*0.01,SUM(VKPMENGE1T2)*0.01,SUM(VKPMENGE1T3)*0.01,SUM(VKPMENGE1T4)*0.01,SUM(VKPPOSWERT)  FROM VKPOS P  WHERE VKKMANDANT=VKPMANDANT AND VKKSA=VKPSA AND VKKAUFKRS=VKPAUFKRS AND VKKAUFLFD=VKPAUFLFD)"
                    + " WHERE VKKSA='  ' AND VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: AND VKKSA='  '"
                    + " AND EXISTS (SELECT 1  FROM VKPOS P WHERE VKKMANDANT=VKPMANDANT AND VKKSA=VKPSA AND VKKAUFKRS=VKPAUFKRS AND VKKAUFLFD=VKPAUFLFD)";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }

        public void UVKK06(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKAUFSTA=:VKKAUFSTA:,VKKKDSTA=:VKKKDSTA:"
                  + " WHERE VKKSA='  ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK07(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKAUFSTA='20',VKKKDSTA='10'"
                + " WHERE VKKSA='  ' AND VKKAUFSTA='21'  AND VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: AND NOT EXISTS"
                + " (SELECT 1 FROM VKPOS WHERE VKPSA='  ' AND VKPMANDANT=VKKMANDANT AND VKPAUFKRS=VKKAUFKRS AND VKPAUFLFD=VKKAUFLFD AND VKPBSTSTA='71') ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK08(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKERL='J'"
                 + " WHERE VKKSA<>'AJ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: AND NOT EXISTS"
                 + " (SELECT 1 FROM VKPOS WHERE VKPSA='  ' AND VKPMANDANT=VKKMANDANT AND VKPAUFKRS=VKKAUFKRS AND VKPAUFLFD=VKKAUFLFD AND VKPERL=' ') ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
        public void UVKK20(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "UPDATE VKKOPF SET VKKSA=:VKKSA:"
                  + " WHERE VKKSA='  ' AND  VKKMANDANT=:VKKMANDANT: AND VKKAUFKRS=:VKKAUFKRS: AND VKKAUFLFD=:VKKAUFLFD: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            Connect2Proxy(or1);
        }
    }
}
